Spring data mongo db find in map of values

Question

I have the following DB structure:

{  id : "1233454",
   name : "abc",
   elements : [ 
        { "1" : { id : "123", referenceId : "567" } },
        { "2" : { id : "345" } },
   ],
},
{  id : "56789",
   name : "def",
   elements : [ 
        { "3" : { id : "123", referenceId : "789" } },
        { "4" : { id : "345" } },
   ],
},
{  id : "98765",
   name : "def",
   elements : [ 
        { "3" : { id : "123", referenceId : "789" } },
        { "4" : { id : "345" } },
   ],
}

and I need to retrieve document id where referenceId is equals to the parameter passed to the method. For example: If method receives "789" it should return "56789" and "98765".

Thanks in advance.

is there any particular rule/schema for the keys in your elements array elements? Can it be any string? — chk
– chk, Commented Dec 13, 2013 at 12:17
id field is the key of the document. "1233454", "56789" and "98765" are document keys. — user1982978
– user1982978, Commented Dec 13, 2013 at 12:27

chk · Accepted Answer · 2013-12-13 12:32:08Z

1

It is not recommended to have unknown keys if you want to query efficiently, see for example this discussion. If your keys in the elements (e.g. "1") follow a certain structure or are limited, you could use a simple $or in the query to check all options such as "elements.1.referenceId" - see here how to do this.

answered Dec 13, 2013 at 12:32

chk

5443 silver badges12 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Spring data mongo db find in map of values

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related