What is the Corresponding query for getting document/documents based on a key and a condition?

Question

Need to get the data inside a array/nested array in MongoDB.

Suppose my Collection is :

{"No" : 1, "Inner":[{"Created By":"A1","Updated By":"AA1"}]}
{"No" : 2, "Inner":[{"Created By":"A2","Updated By":"AA2"}]}
{"No" : 3, "Inner":[{"Created By":"A3","Updated By":"AA3"}]}

and so on...

I Need to find document where No = 3 and Created By = A6

Does this answer your question? [Return only matched sub-document elements within a nested array](https://stackoverflow.com/questions/36229123/return-only-matched-sub-document-elements-within-a-nested-array) — whoami - fakeFaceTrueSoul, Dec 18 '19 at 22:48

DevKyle · Accepted Answer · 2019-12-18T22:35:09.460

0

Based on your question I think a compound query is what you are looking for:

db.collection.find( { "No": 3, "Inner.Created By": "A6" } )

I hope this helps!

edited Dec 18 '19 at 22:35

answered Dec 18 '19 at 22:30

DevKyle

1,091
6
22

What if I have multiple rows inside Inner in each record? – ATHUL KRISHNA N.S Dec 19 '19 at 06:15
I believe you can use "Inner..Created By", but I haven't tested this myself. Will you let me know if you get a chance? – DevKyle Dec 19 '19 at 06:53
As recommended by you, I am able to do the update, by giving the row index. – ATHUL KRISHNA N.S Dec 20 '19 at 08:25
But what if I have array inside, another array and so on... let's assume for now, it goes for atleast 3 levels, is there any way I can update the particular element/whole array – ATHUL KRISHNA N.S Dec 20 '19 at 08:27
I'd imagine you can continue with "." to reach array within an array, but this might be a good topic to ask a separate question so other people can provide answers – DevKyle Dec 20 '19 at 18:09
I am more inclined to use the array filters. I suppose "." won't help me. I will have multiple levels of array. – ATHUL KRISHNA N.S Dec 21 '19 at 13:27

What is the Corresponding query for getting document/documents based on a key and a condition?

1 Answers1