Could you give a bit more information?
First, can you share the object mappings between the two entities/tables?
Second, which type is sectorName? I'm assuming
String, but need to know if sectorName is case-sensitive. If not, try using
Restrictions.ilike() instead of
Restrictions.like().
Jason
Originally posted by Narsimha Reddy:
I have search functionality in my application. Search fields are not belongs to main table.Ids are avaible in main table , corresponding values are avalidable in related table.
I tried using Criterion
crit1=Restrictions.like("sector", sectorName);
detachedCriteria.add(crit1);....
Could some help me out ?