Hi All,

I have got a class mapped to a table and I need to always have something in the where clause when a query is run against this class/table.

I'm using the property "where" in the class element to do that. The problem is that this criteria must be able to receive parameters and I'm not quite sure how to bind the parameter value to the query before loading the object.

It is something like the following:

<class name="test.Facility" table="facility" where="credit_limit > ?">

Is there a way to set it before calling load? Or should I use a different method?

Any help will be much appreciated.
MJ

I believe that you want to use a Filter for this. I haven't gotten it to work myself... actually I'm trying to just get the 'where="some sql here"' to work when I'm doing projection queries. Anyway, here's a URL

http://www.hibernate.org/hib_docs/v3/re ... lters.html