hi! I have a case when I have hundreds of criterias, all of them quering the same type, each of them returning the top 1 result depending on various orders and where qualificants. What I need is the ability to create one huge criteria from them, returning only the top 1 row from their results' union again depending on various orders and where qualificants. I know that criterias don't support subcriteria union now - but is this on the roadmap? if not, do you think it can be done easily? I was thinking about that this differs from criteria junction, but similar to some of the property projections with subqueries...
Peter
