how to query data inside an array of the collection using mongoose

Question

i have a mongoose schema like this :

 var LogsSchema = new Schema({
    date: Date,
    longitude: String,
    latitude: String,
    speed: Number
 });

var DeviceSchema = new Schema({

name: String,
model: String,
phone: {
    type: Number,
    required: true,
    unique: true
},
push: Number,   
logs: [LogsSchema],
})

i have huge array of logs in my database how can i sort limit and skip logs array data ?? currently i am taking only last 10 elements of array but i want to select applying condition . Using $elemMatch doesnot solve my problem it shows from whole collection but i need from individual documents. what is wish is to find logs from date range. Any suggestions are highly appreciated.

Can you show an example query that you have tried and what your expected output is with some sample documents? — chridam
– chridam, Commented Nov 20, 2016 at 12:39

Parshuram Kalvikatte · Accepted Answer · 2016-11-22 14:21:30Z

2

use aggregation framework.$unwind your log array and apply whatever condition you want $sort $match,skip.or you can check $filter in $project stage,please post your expected output I will try my hand

db.collection.aggregate([{"$unwind" : "$logs"},
{$match : {"$and" :  [{"logs.date" :{$gte : fromDate} },
{"logs.date" :{"$lte" : toDate}}]}},
{"$group" : "_id" : "_id",
"logs" : {"$push" : "$logs"},
"names" :{"$first" : "$name"}
}])

Or you can use $filter if using mongodb 3.2

{
  $filter: {
     input: logs,
     as: "num",
     cond: { $and: [
        { $gte: [ "$$num.date", fromDate ] },
        { $lte: [ "$$num.date", toDate ] }
      ] }
  }
}

edited Nov 22, 2016 at 14:21

answered Nov 20, 2016 at 18:20

Parshuram Kalvikatte

1,6465 gold badges23 silver badges45 bronze badges

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

1 Comment

kisor Over a year ago

i want to fetch logs from $gte:"a_date", $lte:"a_date"

Collectives™ on Stack Overflow

how to query data inside an array of the collection using mongoose

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related