Possible to ignore Mapping where parameter

Dencel · **Joined:** Tue Jan 27, 2004 12:22 pm **Posts:** 103

Hello,

In my Mapping file I have this:

Code:

<set name="ranges" table="ranges" order-by="TIME_OF_CREATION desc" where="current > 0">
<key column="customerid"/>
<one-to-many class="Range"/>
</set>

Now I have a query where I want to ignore the where attribute, so it should take all ranges. My query looks like this:

Code:

String hql = "from Customer as customer " +
   "inner join customer.ranges as r " +
   "Where r.from < :ordernumber " +
   "And r.till > :ordernumber";

Now it doesn't return any results because current =0 for all ranges.
Is it possible to create a query ignoring the where=
attribute?

Thanks for helping!

michael · **Posted:** Wed Oct 27, 2004 5:58 am

Looks like something for dynamic filters in H3

Dencel · **Joined:** Tue Jan 27, 2004 12:22 pm **Posts:** 103

Sorry,

I am working on the stable 2.x version of Hibernate.
I will certain take a look at the dynamic filters for H3.

But for now, is there a solution for it in 2.x? Or should I write a native query for it ?

Thanks.