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
Articles by AmitDiwan
Page 599 of 840
Query BinData by Type in MongoDB
To query BinData documents by their subtype in MongoDB, use the subtype() method within a JavaScript function to filter documents based on their binary data type. Syntax db.collection.find(function(){ return this.fieldName.subtype() == subtypeNumber }); Sample Data Let us create a collection with documents containing different BinData subtypes − db.demo249.insertMany([ { "_id": BinData(0, "AQAAAAEBAAVlbl9VSwAAAAAAAAhv") }, { "_id": BinData(4, "CNDF66qIlCY92q1vFAAAAQ==") }, { "_id": BinData(3, "CNDF66qJ29g92q1vFAAAEw==") } ]); { "acknowledged": true, ...
Read MoreMongoDB 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 More