Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

EL in a HQL query

 
Ryan Waggoner
Ranch Hand
Posts: 75
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi guys,
I saw something while reading an article that showed a hql query using EL for on of the parameters, and they said that was better than doing something like user.username.

When I first saw this I was confused, because I didn't know how you would make a query on a page, and use EL.

So I altered my query a little bit...



Project looks like...



It seems it is almost working. But I am getting this error...




So if I may, why is it not able to find the property...and exaclty what I am doing with this EL that would make it better than the one line in the query that I commented out?


Thanks!

 
Edvins Reisons
Ranch Hand
Posts: 364
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
A few minutes of googling found quite a number of people with the same condition, and a solution, rather not surprisingly, from a fellow rancher's blog, that appears to match your situation (look at the WHERE project = " + "#{project.siProjectID} above).
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic