In Mongoose, how to filter an array of objects

Question

I have the following schema:

var sampleSchema = new Schema({
  name: String,
  dates: [{
    date: Date,
    duration: Number
  }]
});

I'd need to filters the records according to the following rule: if one of dates is later than a given date date_begin, keep the record, otherwise, don't.

I have the impression that $gte or $lte are the function I need, but I can't find a way to use them correctly. I tried

sampleSchema.find({date_begin: {$gte: 'date'}});

or some variants of that, but I can't seem to be able to make it work. Anyone has an idea of how I am supposed to do this?

Hector Torres · Accepted Answer · 2018-12-04 06:34:01Z

20

To do querying on elements inside arrays, $elemMatch is used :

SampleModel.find( { dates : { $elemMatch: {  date : { $gte: 'DATE_VALUE' } } } } )

If you're using a single query condition, you can directly filter:

SampleModel.find( { 'dates.date': { $gte: 'DATE_VALUE' } } )

edited Dec 4, 2018 at 6:34

Hector Torres

2831 silver badge5 bronze badges

answered May 1, 2013 at 20:26

DhruvPathak

43.4k17 gold badges125 silver badges180 bronze badges

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

Collectives™ on Stack Overflow

In Mongoose, how to filter 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