how to query value inside of object array in mongoose

Question

I'm trying to get document that it's 'from' field value in 'from' of 'periods' array.

I've tried followings but it doesn't work. how can i?

periods = [{
    from: 333,
    to: 555
},
{
    from: 666,
    to: 777
}]

var eqbookschema = new Schema({
eq_dbId: String,
user_dbId: String,
from: Number,
to: Number,
timestamp: Number,
}, {collection: 'book'});

EQBook = mongoose.model('EQBook', eqbookschema)

EQBook.find({
    eq_dbId: req.body.eq_dbId,
    from: {$in: [periods.from]}
})

The query I have tried only returns empty array although existing.

Cuong Le Ngoc · Accepted Answer · 2019-09-13 10:49:10Z

1

Because periods is an array of object and you want to find based on from field of each element so you need to map it first:

let froms = periods.map(val => val.from);

Then find with mapped array:

EQBook.find({
  eq_dbId: req.body.eq_dbId,
  from: {$in: froms}
})

Or just:

EQBook.find({
  eq_dbId: req.body.eq_dbId,
  from: {$in: periods.map(val => val.from)}
})

answered Sep 13, 2019 at 10:49

Cuong Le Ngoc

12k2 gold badges23 silver badges43 bronze badges

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

6 Comments

thinkmore Over a year ago

is there no other way using mongoose query?

Cuong Le Ngoc Over a year ago

What do you mean? It's using mongoose query, just edit the input to filter result.

thinkmore Over a year ago

using that way, periods not changed?

Cuong Le Ngoc Over a year ago

Yes, .map() doesn't modify the orginal array.

thinkmore Over a year ago

is there no other way using mongoose operator?

|

virender nehra · Accepted Answer · 2019-09-13 10:50:09Z

0

create an array of 'from' values only

periodFrom = periods.map((elem)=>elem.from);

EQBook.find(
  {eq_dbId: req.body.eq_dbId,from:{$in:periodFrom}}
)

edited Sep 13, 2019 at 10:50

answered Sep 13, 2019 at 10:34

virender nehra

6228 silver badges16 bronze badges

2 Comments

thinkmore Over a year ago

as you can see in in the model, EQBook has no 'periods' field.

thinkmore Over a year ago

thank you for your help. you' right, but i can only one accept. sorry.

Pushprajsinh Chudasama · Accepted Answer · 2019-09-13 11:23:55Z

0

You can try this.

const ObjectId = require('mongodb').ObjectId;
let froms = periods.map(data => data.from);
EQBook.aggregate([
{
 $match : {'eq_dbId': ObjectId(req.body.eq_dbId),'from':{$in:[periodFrom]}
}
])

answered Sep 13, 2019 at 11:23

Pushprajsinh Chudasama

7,9994 gold badges23 silver badges48 bronze badges

Collectives™ on Stack Overflow

how to query value inside of object array in mongoose

3 Answers 3

6 Comments

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

6 Comments

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related