Setting up a query to look at a specific index of an array of objects

Question

I'm Having trouble with setting up a query - it is an array of objects, and I'm looking at a specific index. So my Schema has a field that is an array of objects:

{userID: ObjectID,
someArray: [{foo: "bar"},{bar: "foo"}]}

I'd like to return either all records where the first element in SomeArray has a non-empty object or where someArray does not contain null.

Ive tried using:

 db.find({someArray: {$exists: true, $not: {$size: 0}} })

however often someArray has a null object in it so that doesn't work. If all fails I could potentially cache the entire collection and filter with raw javascript though that might not be the ideal way of doing it.

Arm1stice · Accepted Answer · 2015-07-27 20:25:28Z

1

To solve your problem, I suggest using the $ne (not-equal) helper

The implementation in your case:

db.find({someArray: {$ne: null})

answered Jul 27, 2015 at 20:25

Arm1stice

1016 bronze badges

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

Collectives™ on Stack Overflow

Setting up a query to look at a specific index of an array of objects

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