Hibernate Community • View topic - Hibernate Filters Like Condition

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

Hibernate Filters Like Condition

Page 1 of 1

[ 5 posts ]

Previous topic | Next topic

Author

Message

zegloman

Post subject: Hibernate Filters Like Condition

Posted: Fri Aug 19, 2005 2:41 pm

Newbie

Joined: Sun Mar 06, 2005 5:41 am
Posts: 13

Hello,

In hibernate 3 this type of filter works fine:

<filter name="searchText" condition=":searchTextParam LIKE name" />

But how can i get the functionality of LIKE %searchTextParam%? The current filter just does LIKE searchTextParam

Thanks

Top

nathanmoon

Post subject:

Posted: Fri Aug 19, 2005 2:46 pm

Expert

Joined: Wed Apr 06, 2005 5:03 pm
Posts: 273
Location: Salt Lake City, Utah, USA

did you try

Code:

condition="'%' || :searchTextParam || '%' LIKE name"

Top

zegloman

Post subject:

Posted: Fri Aug 19, 2005 5:22 pm

Newbie

Joined: Sun Mar 06, 2005 5:41 am
Posts: 13

Thanks, That did the trick, It seems to work without the "||" double pipes as well. What is their purpose?

Top

nathanmoon

Post subject:

Posted: Fri Aug 19, 2005 5:29 pm

Expert

Joined: Wed Apr 06, 2005 5:03 pm
Posts: 273
Location: Salt Lake City, Utah, USA

string concatenation

Top

poisonives

Post subject: Re: Hibernate Filters Like Condition

Posted: Mon Oct 24, 2011 8:22 am

Newbie

Joined: Sat Oct 22, 2011 8:05 am
Posts: 3

hi
For %LIKE%
I am having the filter condition like this but its saying syntax error in this parameter.
could any one tell me whats wrond in this?
<filter name="origBdgtCpntColumn" condition =" '%' || :origBdgtCpnt ||'%' LIKE ORIG_BDGT_CPNT "/>

Top

Page 1 of 1

[ 5 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