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
Coming together is a beginning. Keeping together is progress.. Working together is success........