specifying an SQL WHERE condition when mapping a collection

shafiq · **Joined:** Mon Nov 29, 2004 7:52 am **Posts:** 1

I was wondering if it were possible to specify a runtime variable in the SQL where condition when mapping a collection. The document explains the usage of the <map> tag (6.2. Mapping a Collection), but I can't find anything on how to specify a variable in the actual where clause.

I really appreciate any help you can afford me.

Thanks

Shafiq

dsambhar · **Joined:** Tue Dec 14, 2004 2:36 am **Posts:** 4

Shafiq,
Would you able to do that? if yes, could you please share the solution?

ernst_pluess · **Posted:** Fri Dec 24, 2004 7:07 am

AFAIK only pure SQL is suported for the where tag.

But you can load your collection with HQL which gives you nice named parameters.

HTH
Ernst

michael · **Posted:** Fri Dec 24, 2004 1:46 pm

Dynamic Filters in H3 does exactly that and more.