Advanced Querying using this plugin about gorm-mongodb

[jkuehn]

Hi there,

it is planned to implement criteria queries for the mongodb-morphia plugin, which will support $or and $where queries. Currently your only way is to use morphia directly for such queries. Like this:

class TestController {
    def mongo // get the mongo handler injected

    def testMorphiaQuery() {
        Query q = mongo.datastore.createQuery(Car.class)
        q.where("this.name == 'X1' || (this.passenger && this.passenger.name == 'Joe')")

        println q.asList()
    }
}

mongo.datastore will return a configured AdvancedDatastore (http://morphia.googlecode.com/svn/site/morphia/apidocs/index.html) from morphia. Hope that helps

[jkuehn]

Also check out the new query method, which gives more convenient access to morphias query api:

With 0.7.5 you can do:

  def list = TestDomain.query([max:100]) { 
    where("this.obj1.obj2.obj3 == 'dud' || this.obj1.obj2 == 'notdud'") 
  }.asList()

see http://jkuehn.github.com/gorm-mongodb/ref/Domain%20Classes/query.html