Query array of arrays in Mongo

Question

How would I query the the followoing: get the value of id '120154' for document '123' (result should be 32')

Collection Name:'Collection'

{
    "_id" : "123",
    "Data" : {
        "_v" : [ 
            [ 
                120154, 
                32
            ], 
            [ 
                120156, 
                "0.940515536000"
            ], 
            [ 
                120157, 
                ISODate("2013-12-26T00:00:00Z")
            ], 
            [ 
                120158, 
                "ABX-HE-AA 06-1"
            ], 
            [ 
                120159, 
                "0A08AG9A4"
            ]
]}}

I'm not sure that's possible, your schema abuses arrays. The inner arrays seem to be key-value pairs, so why not model them as such? — mnemosyn
– mnemosyn, Commented Jan 27, 2014 at 12:08

arunb2w · Accepted Answer · 2014-01-27 12:20:11Z

1

db.collection.find({"_id" : "123"},{"Data._v.$1" : {"$in" : {120154}}}). I think this should work when u know the _id for the document.

answered Jan 27, 2014 at 12:20

arunb2w

1,1961 gold badge11 silver badges29 bronze badges

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

Comments

M Omayr · Accepted Answer · 2014-01-28 10:31:18Z

1

I had the same problem and so far I'm unable to find the solution because mongodb queries always return a whole document but you can project fields but that won't return you 32. So when you query {_id : 123} AND {no matter what else}, It will return you the matching whole documents not inner arrays.and I might be wrong but that's what I've experienced

answered Jan 28, 2014 at 10:31

M Omayr

1,3511 gold badge9 silver badges19 bronze badges

Collectives™ on Stack Overflow

Query array of arrays in Mongo

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related