Exlcuding an item from a list in mappings

giGGler · **Posted:** Tue Dec 18, 2007 12:34 pm

hi,

i've got two tables

Code:

[Container]-->[Modules]

Container has a list of modules and also container has an attribute named *special* that points to a, ehm, special module.

I want to map the list of modules exluding the *special*. Before adding the *special* feature I coded the relationship as a list:

Code:

<list name=modules" table="UI_MODULES" lazy="false" fetch="join">
   <key column="UUID_CONTAINER"/>
   <list-index column="position"/>
   <one-to-many class="domain.Module"/>
</list>

and now added the *special* mapping:

Code:

<many-to-one name="special" class="domain.Module" column="special_uuid" lazy="false" insert="false" update="false" not-null="true"/>

How do I exclude from the list the desired module??

In SQL it could be

Code:

where ui_modules.uuid <> container.special_uuid

thanks!!!!

Hibernate version: 3

plasmafire · **Posted:** Tue Dec 18, 2007 12:42 pm

Happy holidays :)

Would filters be what you are looking for?
http://www.hibernate.org/hib_docs/v3/reference/en/html/objectstate.html#objectstate-filtering

I believe the SQL example that you posted would have the hibernate equivalent of

Code:

Criteria crit = session.createCriteria(Cat.class);
crit.add( Expression.ne( "color", eg.Color.BLACK ) );

giGGler · **Posted:** Tue Dec 18, 2007 1:02 pm

Happy holidays ;)

I am trying to get it thru the mapping file because the modules list is aggresivelly loaded while retrieving the container.

Thanks!!

plasmafire · **Posted:** Tue Dec 18, 2007 1:55 pm

Sorry, I had this in mind. You could apply a default filter condition not equals

http://www.hibernate.org/hib_docs/reference/en/html/filters.html

giGGler · **Posted:** Tue Dec 18, 2007 2:43 pm

is the filter automatically applied??

I mean, what i need is to apply the filter always, when the list is retrieved...

plasmafire · **Posted:** Wed Dec 19, 2007 8:24 am

The default filter is always automatically applied.
I can see that is the case while using loadAll(class) method.

giGGler · **Posted:** Wed Dec 19, 2007 8:34 am

I just added

Code:

to fix this.

Thanks for your help!!

plasmafire · **Posted:** Wed Dec 19, 2007 9:41 am

Glad to be of service, and thanks for the credit