I have the HQL query like.Please let me know how to write criterian query for this.
String queryString = "from Customer as customer where customer.username like '%"+customer+"%' and " +
" customer.statusMap="+StatusMapInterface.ACTIVE+" and " +
" customer.customerId in (select distinct cRole.customer from CustomerRole as cRole where cRole.role!="+RoleMap.SITEADMIN+")" +
" order by registeredDate asc ";

In the above query Customer is the parent table. Customer_Role is the child table.In that customer_id the foreign key to Customer table.

Please let me know how to write subquery in "in clause" using criterian api of hibernate. My subquery is like

select distinct cRole.customer from CustomerRole as cRole where cRole.role!="+RoleMap.SITEADMIN.
In above subquery i want only one column customer_id which is the foreign key.

I had spent almost 10 hours for this. Even i cant get this.
Please any one give reply

Thanks in Advance..