between query on mongodb

ساخت وبلاگ

Vote count: 0

i have this collection

{ "_id" : ObjectId("57b8277cd48b97d6e38d9eb2"),

"student_id" : "326598",
"sem" : "sem1",
"marks" : [ { "title" : "english", "from" : 2, "to" : 15 }, { "title" : "maths", "from" : 5, "to" : 18 }, { "title" : "science", "from" : 10, "to" : 20 }
]

}

{ "_id" : ObjectId("52873b7e4038253faa4bbc10"),

"student_id" : "124578",
"sem" : "sem1",
"marks" : [ { "title" : "english", "from" : 1, "to" : 20 }, { "title" : "maths", "from" : 6, "to" : 16 }, { "title" : "science", "from" : 12, "to" : 20 }
]

}


and write this query :

var x= 7;
db.getCollection('numbers').aggregate([
{$unwind : "$marks"},
{$match : {$and :[{"marks.from": { $gte :2 } },{"marks.to": { $lte :15 } } ]}}
])

i want return each document contains X value is in range between from and to . for example return document that have X value great than marks.from and less than marsk.to . but that query didnt work.

asked 48 secs ago

back soft...
ما را در سایت back soft دنبال می کنید

برچسب : between query in mongodb, نویسنده : استخدام کار backsoft بازدید : 351 تاريخ : شنبه 30 مرداد 1395 ساعت: 17:20