Hi -
Is it possible to query against a local column value if that column is the key in a mapped relationship?

i.e. Option contains


I want all Options where Option.optionTypeId == 0. This should left-outer join the mapped OptionType (because in this database, 0 means record does not exist). Result would be Option with a null OptionType.

I've tried a number of things, but of course the Option.optionTypeId is not really a recognized field, independent its mapping. Should a SQLQuery be able to get around this? So far I have not gotten that to work.

Thanks for ideas.

It seems like it should be possible but the solution I went with was just to add dummy data with the ID of 0.

This would be done in SQL like


I started going down the route of using a SQLQuery but it couldn't find my entity for some reason (yes I followed http://docs.jboss.org/hibernate/core/3. ... l#d0e13646) and I ran out of time to mess with it.

Can anyone answer if this should be possible at least?