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, 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:
>
> <class-descriptor class="de.on_ergy.lakon.data.model.User" table="user">
> <field-descriptor name="objId" column="obj_id"
> jdbc-type="INTEGER" primarykey="true"
> autoincrement="true"></field-descriptor>
> <field-descriptor name="username" column="user_name"
> jdbc-type="VARCHAR" length="100" ></field-descriptor>
> <!-- m - n über benutzer_gruppen zu gruppen -->
> <collection-descriptor
> name="groups"
>
> collection-class="
> org.apache.ojb.broker.util.collections.ManageableArrayList"
> element-class-ref="de.on_ergy.lakon.data.model.Group"
> auto-retrieve="true"
> auto-update="false"
> auto-delete="link"
> proxy="true"
> indirection-table="user_group"
> >
> <fk-pointing-to-this-class column="user_obj_id"/>
> <fk-pointing-to-element-class column="group_obj_id"/>
> </collection-descriptor>
> </class-descriptor>
>
> How can I get all Users, which currently not in a Group?
> Is there a way like this?
> Criteria crit = new Criteria();
> crit.addIsNull("groups");
>
> Thanks a lot for your help!
>
> regards
>
> --
> Josef Wagner
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
