Hi,
Well, if you have made a DB index on table "Group" strating with the foreign
key of Users, it's necessary the fatest query.
By "Query anything light", i mean, field is not important, putting something
useless don't let any doubt on the utility of this (sub)query.
On 12/7/06, Vasily Ivano
Hello,
I usually do criteria.addNotExists(subQuery) with
ReportQueryByCriteria subQuery and set subQuery.setAttributes(new
String[] { "1" }), it should be even faster than "anything ligth of
Group (key field by example)".
Cheers,
Vasily
On 12/7/06, Bruno CROS <[EMAIL PROTECTED]> wrote:
Well,
Well, try notExists criteria and a subquery on Group returning anything
ligth of Group (key field by example)
Bruno.
On 12/6/06, Josef Wagner <[EMAIL PROTECTED]> wrote:
Hello List,
I want to have all "Users", which are not in a "Group"
Here my repository:
How
Hello List,
I want to have all "Users", which are not in a "Group"
Here my repository:
jdbc-type="INTEGER"primarykey="true"
autoincrement="true">
jdbc-type="VARCHAR" length="100" >
collection-class="org.apache.ojb.broker.util.collections.ManageableArrayLi