Grails findWhere not equal

Question

Is there a way to use findWhereand not equal value (trying to use it against the criteria)?

eg.

Books.findWhere('sale' : true, 'category': ne('exclude me') )

I have a working solution, but I was wondering if there is a way to use findWhere. I find it easier to read it.

def result = Books.createCriteria().get{
            eq('sale', true)
            ne("category", 'exclude me')
}

+5

Nix Mar 18 '13 at 15:09

2 answers

codelark · Answer 1 · 2013-03-18T15:25:46+0000

You can use either dynamic search methods:

Books.findAllBySaleAndCategoryNotEqual(true, 'exclude me')

or where are the requests (which use DetachedCriteria:

Books.findAll {
     (sale == true) && (category != 'exclude me')
}

Ian roberts · Answer 2 · 2013-03-18T15:29:34+0000

I don’t know how to do this with help findWhere, but there is good syntax for dynamic crawlers with two properties, where one isboolean

Books.findSaleByCategoryNotEqual('exclude me')

(or findNotSaleBy...if you want the sale to be false).