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]