If I want to search those students who take class "Math" and "John" is his group: shoud I use createCriteria or createAlias? Criteria: Criteria criteria = session.createCriteria(Student.class); ...

I have a domain object (Cat) like this: class Cat { String name static hasMany = [ nicknames: String ] } (A cat has a name, and also has many nicknames (which are Strings)) And I am trying...

It seems that in Grails 2.x, if you have a domain class association, and you try to run a createCriteria using or on that relation + another query, the or will ignore the other query and just use t...

When using projection on the properties, the result is returned as the list with the elements in the same sequence as that defined in the projections block. At the same time the property names are ...

Is it possible, to query grails with criteria and receive a list of maps instead of a list of lists? I would like to have the column names in the results in order to then work with an 'associative ...

I'm working on building a createCriteria dynamically. So far, so good: obj is the domain object(s) I want back rulesList is a list of maps which hold the field to be searched on, the operator to u...

I have an Auction domain object and a User domain object. An Auction hasMany Users. What I'd like to do, using createCriteria, is something like this: def c = Auction.createCriteria() def l = c.l...

I am using HibernateCriteriaBuilder api to write my Criteria Queries. I want to know if inside Criteria we can have conditional logic, such as an if statement? For example: OnemonthList=it.creat...

How can I write the following SQL using CreateCriteria: SELECT * FROM FooBar fb WHERE EXISTS (SELECT FooBarId FROM Baz b WHERE b.FooBarId = fb.Id)