Grails query not inList

Question

I'm writing a criteria to make a query, but I can't figure out how to negate an inList criteria...Is there a way to do something like:

def result = c {
     not inList('id', ids)
}

Thanks

Answer 1

Your criteria should like this...

def ids = [1, 2, 3];

def c = Foo.createCriteria();
def results = c.list {
  not {'in'("id",ids)}
}

The documentation can be found here. I believe this was just added in grails 2.+