Hi,
I have a many-to-many relation and I would like to implement the following "statement" using Hibernate criteria API (the output must be a criterion):
<relationListPropertyname> contains all <valuelist>.
For example, let's say that
<valueList>=('a', 'b')
and I have 2 rows in the DB with the following values in the relationList
Row 1: ('a')
Row 2: ('a','b','c')
Row #2 answers the criteria, row #1 doesn't because it doesn't contains 'b'.
I've managed to implement "is one of" using Restrictions.in, but have not succeeded to implement this "contains all".
Please assist.
Thanks in advanced
Carmel
|