Hi All,
I am using
Hibernate version: 2.1.7

I have a collection which I need to filter using certain criteria. I want to do it using session.filter()

The following is the code snippet to give a more clear picture

String filterQuery = "WHERE this.deleteFlag=0 AND this.brand.id in
(SELECT bacl.brand.id
FROM BrandAclentry bacl
WHERE bacl.aclentry.id in (:baclIds)
AND bacl.deleteFlag=0)";

I have a arraylist named say aList containing (1,2,3,4) which i want to be replaced for :baclIds in the filterQuery.

Collection coll = session.filter
(obj.getBrandSpecialities(), filterQuery, aList, ListType(""));

My question is what should be specified in the last parameter, i.e. the Type in the filter() call. I went through the documentation and say a type ListType, but couldn't figure out what should be given as "role" in the constructor for ListType().

Regards,