MongoDB / meteor query match on json object inside an array?

Question

I am struggling to query on a json object inside an array of json objets, is this possible? if not any alternatives you would recommend?

availability : [{
              date: date,
              times: [{
                start:timeAvail[timeStart],
                end: timeAvail[timeEnd]
              }]
            }];

I want to query on date to get all objects with a certain date and get the array of all objects that match like [{date: x, time: [y]}] I've tried this but doesn't return:

Collection.find({availability: {$in: [{date: "2016/10/2"}]}}).fetch()

Larry Weidig · Accepted Answer · 2016-10-02 20:24:35Z

3

Collection.find({'availability.date': {$eq: new Date("2016/10/02").toISOString}}).fetch()

should do the trick.

edited Oct 2, 2016 at 20:24

answered Oct 2, 2016 at 20:21

Larry Weidig

1612 silver badges7 bronze badges

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

2 Comments

Tangleman Over a year ago

Awesome, thanks! Is there anyway to have it return only the date & times elements matched instead of the whole tuple?

maxko87 Over a year ago

yes, see here: docs.mongodb.com/manual/tutorial/…

Collectives™ on Stack Overflow

MongoDB / meteor query match on json object inside an array?

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related