find by key in a map in grails domain mongodb

Question

I am using mongodb plugin with grails (latest versions).

I have a domain similar to:

class User
{
  HashMap baseAddr
  static mapWith = "mongo"
}

The User data in DB is like:

{
        "_id" : NumberLong(1),
        "baseAddr" : {
                "buildingNo" : "",
                "level" : "",
                "side" : "",
                "street" : "asdfasdf",
                "zipcode" : "asdfasdf",
                "state" : null,
                "municipality" : null,
                "flatNo" : "adsfasdf",
                "city" : "New Delhi",
                "country" : "IN"
        },
        "version" : 0
}

I want to find all those Users who have baseAddr.city == "New Delhi" using grails dynamic finder or criteria. Please help

Lalit Agarwal · Answer 1 · 2014-04-16T09:45:42.840

1

The way you have defined your domain model, I think it is not possible to do this with finder or criteria.

You should have created an Address domain and associated that domain here in User class instead.

class User
{
  Address baseAddr
  static mapWith = "mongo"
}

Class Address
{
   String buildingNo
   ....
}

However with the current implementation which you have you could directly use Gmongo in your code and get the data out.

def mongo = new GMongo()
def db = mongo.getDB("db")

def citydoc = db.user.find(["baseAddr.city": "New Delhi"])

edited Apr 16 '14 at 09:45

answered Apr 16 '14 at 09:35

Lalit Agarwal

2,354
1
14
18

Thanks @Lalit.Earlier I was not aware of Gmongo.Here is the link for others https://github.com/poiati/gmongo – akash777.sharma Apr 17 '14 at 02:27

score 1 · Accepted Answer · answered Apr 21 '14 at 06:29

1

You can use with criteria of gorm here is code

def testData =  User.withCriteria {
                eq("baseAddr.city", "New Delhi")
            }

i tested this code this working fine

answered Apr 21 '14 at 06:29

R. S.

402
5
17

Thanks. Following code is also working : ArrayList userList = User.createCriteria().list() { eq("baseAddr.city", "New Delhi") } – akash777.sharma Apr 21 '14 at 07:20

find by key in a map in grails domain mongodb

2 Answers2