i'm trying out a criteria build dynamically from information i get from say a beaninfo object.

say A-->C one to many. i want to add an expression such that i want results only if A.getMultiC() (which results a List of Cs) has more than one element in it. now i 'wish' i could add something like this but this results in a ambiguous query.



if i add "multiC" with .createCriteria() then of course it will introspect each of the list elements but that's not what i'm looking for.

probably just my usage issue?

regards
ravi

I don't understand why this doesn't work:




Did you try it?

yes that will work to find all As which don't return an empty list for getMultiC().

my purpose is to make a count available where i want to be able to add a criteria using the list size as the property (e.g. "multiC.size" >= n).

now i tried to add a custom method on ClassA as getMultiCSize() that simply returns the list size (unsafe) and tried but that didn't really work out.

suggestions?
thanks

hmm, no luck with this. i tried two different ways but i couldn't emulate what i can do with OQL to the effect of "cat.kittens.size > 2".

anyone tried this?