Hi everybody,

I have an SQL query like

select cu1.last_name from content_user cu1
where lower(cu1.last_name) like lower('%gupta%');

. How can I convert this into HQL query like the following


select cu from com.manic.ContentUser cu where cu.lastName = lower(:lastName).......


Here I want to use the "like" condition for %guta% format.




THanks in advance

sessionobject .createCriteria(com.manic.ContentUser.class)
.add(Expression.like("firstName", "%guta%"))

Hey,

If I want the firstName from 2 CLasses then how can I do that. For example I have 2 POJO ContentUser cu and ContentUserRole cur


I need to do like this

cu.firstName like ('%guta%') and cur.firstName like('%guta%'). For this scenario how can i do the criteria.



Thanks

[quote]
cu.firstName like ('%guta%') and cur.firstName like('%guta%'). [/quote]

select first name from cu.firstName from cu table1, cu table2 where

cu.firstName like :parameter and cur.firstName like :parameter

wherein u pass the parameter to be %gupta% from ur DAO.

Hi,

You can use something like following HQL query :

select cu.last_name from com.manic.ContentUser as cu where lcase(cu.last_name ) like '%gupta%'

Hey satsranchuser,
I followed your suggestion , it's doing god man.. Thanks very much..