Grails embedded query array

Question

i have a code like this on grails mongodb

//myDomain
class Plugin {
    List<String> projects = []
    //projects has name and description
}

//myController
def query = null
    if (params.q != null)
    {
        def q = '%'+ params.q +'%'
        query = Plugin.where {
            (projects.name =~ q || projects.name ==~ q)
        }
    }
//return null

why i can't find plugin by projects.name?

Need more code to answer. What/how do you return exactly? Also: maybe `params.q` is `null`? — eugene82, Jan 23 '13 at 13:17
Mongo only supports basic types List, so you probably want to do List and a hasMany. — Tomas Lin, Jan 23 '13 at 13:18
Also, if it is a list, shouldn't it be something like projects*.name? — Tomas Lin, Jan 23 '13 at 13:18
"projects": { "0": { "description": "123", "name": "cms" }, "1": { "description": "cms", "name": "codebucks" } } example i want to find when projects.name == 'cms', how i query in mongo? thanks anyway — rsijaya, Jan 23 '13 at 18:04

score 0 · Accepted Answer · answered Jan 24 '13 at 03:31

0

From the property definition

List<String> projects = []

the elements of projects are Strings, that's why you can not query projects.name, which is not known to GORM.

And in your last comment, the value in a projects instance "projects": { "0": { "description": "123", "name": "cms" }, "1": { "description": "cms", "name": "codebucks" } } looks like a Map, where the project number is the key and a inner map containing name and description is the value, rather than a List.

To serve your purpose, you need to modify your domain class definition to ensure consistency between your model and data.

answered Jan 24 '13 at 03:31

coderLMN

3,076
1
21
26

hi. thx for your answer, i finish it with createCriteria, i get projects.name, thx anyway. – rsijaya Jan 24 '13 at 15:43
So you made it with `List projects = []`? I wonder how did you do that. Could you please post your solution as an answer? – coderLMN Jan 24 '13 at 17:14
yes, i use List projects, and my controller method def listPluginByProject() { def objectInstanceList = [] def q = '%'+ params.q +'%' def c = Plugin.createCriteria() def results = c.list { like('projects.name', q) } objectInstanceList = results } – rsijaya Jan 25 '13 at 02:29
i don't know why createCriteria still works without hibernate, i use grails 2.1.1, but maybe for safe i try with your suggest to modify domain class, or find another query. – rsijaya Jan 25 '13 at 03:17
Because mongodb gorm plugin provides similar functions. – coderLMN Jan 25 '13 at 03:27

Grails embedded query array

1 Answers1