CODEWITHSUNDEEP
grailsdynamicfinder
VictorArgentin
VictorArgentin

Reputation: 433

Grails using dynamic finders with 3x+ logical arguments

I sucessfully managed to search in the database using this dynamic finder from Hibernate:

def temp = User.findByNameAndStreet("name", "street")

Although, i need a tripple logical argument like this:

def temp = User.findByNameAndStreetAndCity("name", "street", "city")

Any simple way to do it ?

Upvotes: 3

Views: 1091

Answers (1)

Dónal
Dónal

Reputation: 187529

The Grails dynamic finders don't support more than two predicates. This is because it's not clear whether

User.findByNameAndAgeOrGender('foo', 12, 'm')

means this:

(name == 'foo' && age == 12) || gender == 'm'

or this:

name == 'foo' && (age == 12 || gender == 'm')

Admittedly if the predicates are always combined with And or Or.

Update: since Grails 1.4 you can have an unlimited number of predicates if they're all combined with either And or Or

Instead, you can use either findWhere or findAllWhere (depending on whether you want just the first result or all results). Both of these support an unlimited number of predicates which I assume are combined with And, for example:

User.findAllWhere(name: "foo", age: 12, gender: 'm')

Upvotes: 7

Related Questions