CODEWITHSUNDEEP
grailsmongodbgrails-orm
Dean Moses
Dean Moses

Reputation: 2382

Grails + MongoDB: what's a replacement for association query criteria?

The MongoDB plugin for Grails (mongodb 1.0-M5) doesn't (yet) support queries of type AssociationQuery. This means I can't do this:

// Find all instances of MyDomainClass whose myHasOneObject.id is in listOfIds
// Throws exception b/c Mongo doesn't support AssociationQuery
MyDomainClass.withCriteria {
    myHasOneObject {
        inList('id', $listOfIds)
    }
    [...]

// FYI, class declaration looks like this:
class MyDomainClass {
    AnotherDomainClass myHasOneObject
    [...]

What's an alternative way to do queries like this in MongoDB in Grails?

Thanks!

Upvotes: 2

Views: 763

Answers (1)

Graeme Rocher
Graeme Rocher

Reputation: 7985

MongoDB doesn't support join queries, so you need to do 2 queries or denormalize your data

Upvotes: 1

Related Questions