Hibernate Community • View topic - filter condition problem

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

filter condition problem

Page 1 of 1

[ 3 posts ]

Previous topic | Next topic

Author

Message

ruscov

Post subject: filter condition problem

Posted: Thu Apr 16, 2009 5:58 am

Newbie

Joined: Thu Jan 24, 2008 4:03 am
Posts: 2

Hi,

I try to put a filter in my hbm.xml file but I have a problem with my condition.

Here is my condition :

Code:

<filter name="effectiveTimeInstantFilter" condition="START_DATE <= :effectiveDate AND (END_DATE IS NULL OR END_DATE >= :effectiveDate)"/> 

Off course the condition is bad writen but I don't know how to correctly write this condition.

Can anyone help me?

Thank you!

Top

parmendratyagi

Post subject:

Posted: Thu Apr 16, 2009 7:24 am

Regular

Joined: Thu Sep 06, 2007 2:22 am
Posts: 108
Location: Noida,India

I think, problem is due to you are using same name parameter two time.

Use different name for both name parameter, but you can pass same value to both parameter when setting value for name parameter.

Top

ruscov

Post subject:

Posted: Thu Apr 16, 2009 8:01 am

Newbie

Joined: Thu Jan 24, 2008 4:03 am
Posts: 2

I finally found the solution.

I use CDATA tag :

Code:

<filter name="effectiveTimeInstantFilter">
            <![CDATA[
            START_DATE <= :effectiveDate AND (END_DATE IS NULL OR END_DATE >= :effectiveDate)
            ]]>            
             </filter> 

It works perfectly.

Thank you for the quick reply.

Top

Page 1 of 1

[ 3 posts ]

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum