试图提出一种简洁的方法来创建带有NOT IN子句的命名查询。限制类似乎没有“not in”构造。有人知道这样做的好方法吗？

解决方案:

static namedQueries = {
        activeOnly {
            eq 'active', true
        }
        open {
            ne 'state', this.STATE_COMPLETED
        }
        my { user ->
            or {
                eq 'createdBy', user
                eq 'reviewer', user
                eq 'assignee', user
                eq 'requestedFor', user
                ilike 'notifyList', "%$user%"
            }
        }
        topLevel {
            not {'in'('type', [RequestType.Part])}
        }
    }

Request.activeOnly.open.topLevel.list(params)

最佳答案

也许像这样冒昧:

Book.findAll("from Book b where b.author not in (?)", ['Borges', 'Sabato', 'Cortazar'])

Book.withCriteria {
    not {
        'in'('author', ['Borges', 'Sabato', 'Cortazar'])
    }
}

https://stackoverflow.com/questions/10002796/