Hibernate Community • View topic - How to do a not equals search using Example/Criteria APIs

View unanswered posts | View active topics

Board index » Projects » Search, Validator, Shards

All times are UTC - 5 hours [ DST ]

How to do a not equals search using Example/Criteria APIs

Page 1 of 1

[ 3 posts ]

Previous topic | Next topic

Author

Message

jimmyf

Post subject: How to do a not equals search using Example/Criteria APIs

Posted: Wed Mar 30, 2011 6:02 pm

Newbie

Joined: Wed Mar 16, 2011 10:54 am
Posts: 4

Hi,
Gradually getting my head around the Criteria API and how easy it can make database lookups. However , I cannot find a way to do an sql notEquals equivalent search. ie Setup an Example object with property name = "mick" and then pass this to the criteria API and have it return me a list of all instances who's name is NOT = "mick".

Is this possible?

Thanks

Top

hardy.ferentschik

Post subject: Re: How to do a not equals search using Example/Criteria APIs

Posted: Thu Mar 31, 2011 2:44 am

Hibernate Team

Joined: Thu Apr 05, 2007 5:52 am
Posts: 1689
Location: Sweden

Hi,

there is

Code:

Restrictions.eq( "name", "mick" )

for equals and:

Code:

Restrictions.ne( "name", "mick" )

for not equals.

Is this what you are after?
Btw, this is really a questions for the Hibernate Users forum ;-)

--Hardy

Top

jimmyf

Post subject: Re: How to do a not equals search using Example/Criteria APIs

Posted: Thu Mar 31, 2011 4:49 pm

Newbie

Joined: Wed Mar 16, 2011 10:54 am
Posts: 4

Thanks for reply, that was it. I thought I had this one was in the users forum :( cheers

Top

Page 1 of 1

[ 3 posts ]

Board index » Projects » Search, Validator, Shards

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