Article Categories
- All Categories
-
Data Structure
-
Networking
-
RDBMS
-
Operating System
-
Java
-
MS Excel
-
iOS
-
HTML
-
CSS
-
Android
-
Python
-
C Programming
-
C++
-
C#
-
MongoDB
-
MySQL
-
Javascript
-
PHP
-
Economics & Finance
MongoDB Articles
Page 53 of 111
MongoDB aggregate to convert multiple documents into single document with an array?
MongoDB aggregation pipeline allows you to group multiple documents into single documents containing arrays. Use the $group stage with $push operator to combine documents sharing a common field into a single document with an array field. Syntax db.collection.aggregate([ { $group: { _id: "$groupingField", arrayField: { ...
Read MoreMongoDB query to skip n first documents?
To skip a specific number of documents in MongoDB, use the skip() method along with limit(). The skip() method bypasses the first n documents and returns the remaining documents from the result set. Syntax db.collection.find().skip(n).limit(count); Sample Data Let us create a collection with documents ? db.demo246.insertMany([ {"StudentFirstName": "Chris", "StudentLastName": "Brown"}, {"StudentFirstName": "John", "StudentLastName": "Doe"}, {"StudentFirstName": "John", "StudentLastName": "Smith"}, {"StudentFirstName": "Carol", "StudentLastName": "Taylor"} ]); { "acknowledged" : true, ...
Read MoreCoalesce values from different properties into a single array with MongoDB aggregation
To coalesce values from different properties into a single array in MongoDB, use the $group stage to collect values with $addToSet, then $project with $setUnion to merge them into one unified array. Syntax db.collection.aggregate([ { $group: { "_id": null, "property1": { $addToSet: "$field1" }, "property2": { $addToSet: "$field2" } ...
Read MoreA single MongoDB query to orderby date and group by user
To order by date and group by user in a single MongoDB query, use the aggregate() method with $group and $sort stages. This approach groups documents by user and finds the maximum date for each user, then sorts the results. Syntax db.collection.aggregate([ { $group: { _id: "$userId", dueDate: { $max: "$dueDate" } } ...
Read MoreEasiest way to sort an array in MongoDB
The easiest way to sort an array in MongoDB is to use the aggregation pipeline with $unwind, $sort, and $group operators. This approach unwraps the array, sorts the elements, and reconstructs the document. Syntax db.collection.aggregate([ { $unwind: "$arrayField" }, { $sort: { "arrayField.sortField": 1 } }, { $group: { _id: "$_id", arrayField: { $push: "$arrayField" } } } ]); Sample Data db.demo242.insertOne({ "details2": [ { "ShipingDate": new ISODate("2019-10-11"), "Price": ...
Read MoreGet the maximum mark records from a collection with documents in MongoDB
To get the maximum mark records from a collection in MongoDB, use the $sort and $limit aggregation operators to sort documents by marks in descending order and retrieve only the top records. Syntax db.collection.aggregate([ { $sort: { marks: -1 } }, { $limit: numberOfRecords } ]); Sample Data Let us create a collection with student documents containing marks − db.students.insertMany([ { "StudentName": "Chris", "marks": 85 }, { "StudentName": "Bob", "marks": 92 }, ...
Read MoreMongoDB query for documents whose array elements does not have a specific value
To query documents whose array elements do not have a specific value in MongoDB, use the $elemMatch operator combined with $exists: false. This finds documents containing arrays where at least one element lacks the specified field. Syntax db.collection.find({ "arrayField": { "$elemMatch": { "fieldToCheck": { "$exists": false } } } }); Sample Data Let us create a collection with ...
Read MoreImplement MongoDB Aggregate - unwind, group and project?
The MongoDB aggregation framework allows you to process data through a pipeline of stages. Three powerful operators - $unwind, $group, and $project - can be combined to deconstruct arrays, group documents, and shape the output. Syntax db.collection.aggregate([ { $unwind: "$arrayField" }, { $group: { _id: "$groupField", result: { $operator: "$field" } } }, { $project: { field1: 1, field2: 1, _id: 0 } } ]); Sample Data db.demo238.insertMany([ { ...
Read MoreRemove all except a single field from a nested document via projection in MongoDB
To remove all except a single field from a nested document in MongoDB, use projection with the find() method. Set unwanted fields to 0 to exclude them, keeping only the desired field visible. Syntax db.collection.find( {}, { "nestedDocument.unwantedField1": 0, "nestedDocument.unwantedField2": 0 } ); Sample Data db.demo237.insertOne({ _id: 101, Product: { ...
Read MoreHow to sort, select and query subdocument in MongoDB?
To sort, select and query subdocument in MongoDB, use the aggregation pipeline with $unwind, $project, and $sort stages. This approach extracts subdocument fields, selects specific fields, and sorts the results. Syntax db.collection.aggregate([ { $unwind: "$subdocumentField" }, { $project: { field1: "$subdocumentField.field1", field2: "$subdocumentField.field2" }}, { $sort: { field1: 1 } } ]); Sample Data db.demo236.insertMany([ {"details":{"Name":"Chris", ...
Read More