I checked the DTD but did not find any hints. What I'm looking for. We have all static texts of dropdown lists etc. stored in one single table in the database with one column being used to distinguish the different dropdown boxes. Currently the WHERE clause is part of our HQL statement. That works find but is a little bit inflexible. I thought itdd be nice to have the WHERE clause being part of the mapping file, part of the <set>, <bag> etc. definition. Is that possible?

regards
Juergen

Yes, just use the where attribute of your set mapping and put any sql code there.