Menu
I want to fetch 100 records from a student collection sort by name. Now i want to get student who has marks greater than x in this 100 records only. Can any one please help in solving this. When i give Max(marks) in query it is executing before the sort and skip.
This the query i tried
var query = {};
query["marks"] = {$gt:35};
db.collection("student").find(query).skip(0).limit(100).sort("name")
339
Fetch all data from the collection If we want to fetch all documents from the collection the following mongodb command can be used : >db. userdetails. find(); or >db.
Use the $in Operator to Match Values This query selects all documents in the inventory collection where the value of the quantity field is either 5 or 15. Although you can write this query using the $or operator, use the $in operator rather than the $or operator when performing equality checks on the same field.
Use the $text query operator to perform text searches on a collection with a text index. $text will tokenize the search string using whitespace and most punctuation as delimiters, and perform a logical OR of all such tokens in the search string.
When your query is described in steps as in this case, the ability of aggregate to pipeline results from the output of one operation to the input of the next makes it a natural choice:
db.student.aggregate([
// First sort all the docs by name
{$sort: {name: 1}},
// Take the first 100 of those
{$limit: 100},
// Of those, take only ones where marks > 35
{$match: {marks: {$gt: 35}}}
])
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
