posted 15 years ago
Hi There,
I am trying to build Search option on a SINGLE table USER_PROFILES in my application.
This search plan was, we are going get FirstName,LastName,EmailAddress and an arry of UserType's. We need to search
" (FirstName AND LastName AND EmailAddress and 'usertype1') OR
(FirstName AND LastName AND EmailAddress and 'usertype2') OR
..... SO ON
"
Bellow is the example querry:
Bellow is my Hydernate code I am trying to build for this
I know, I was trying to build this using this
Criterion u_type = Restrictions.like("siteId",""+searchRequestData.getSiteId())
For this Restrictions, every time we need to pass two different arguments, so I understand its between two values not for arguments.
So I struggling to build this and finding how to do this.
Please help me, thanks,VIJAY
Vijay Gadde
Coming together is a beginning. Keeping together is progress.. Working together is success........