MongoDB: query Array for 'true' value at index n

Question

So I have this collection containing a field "weekdays" representing weekdays Monday-Sunday (checked or not checked):

  var collection = [

    // work week (Monday to Friday)
    {
      weekdays: [true, true, true, true, true, false, false]
    },

    // weekend
    {
      weekdays: [false, false, false, false, false, true, true]
    },

    // ...

  ];

Now, how can I query this collection to find all items that has true for a specified weekday?

My first attempt was to use something like this:

// $elemMatch...

'weekdays[0]': true // Monday

But it did not seem to work. I'm out of ideas atm and would appreciate any help!

Don't claim to ask about 'truthy' while actually asking about 'true' - they're different things! — Erwin Wessels
– Erwin Wessels, Commented Jan 7, 2016 at 7:20

Disposer · Accepted Answer · 2014-11-13 19:09:18Z

2

you can use this code

db.collectin.find({'weekdays.0' : true})

and if you want check 2 days:

db.collectin.find({$and : 
    [
        {'weekdays.0' : true},
        {'weekdays.1' : true}
    ]
})

answered Nov 13, 2014 at 19:09

Disposer

6,3915 gold badges34 silver badges39 bronze badges

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

Collectives™ on Stack Overflow

MongoDB: query Array for 'true' value at index n

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related