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
Big Data Analytics Articles
Page 19 of 135
How to find if element exists in document - MongoDB?
To find if an element exists in a MongoDB document, use the $exists operator. This operator checks whether a specified field is present in the document, regardless of its value. Syntax db.collection.find({"fieldName": {$exists: true}}); db.collection.find({"fieldName": {$exists: false}}); Sample Data db.demo497.insertMany([ {"details": [{"Name": "Chris"}, {"Name": "Bob"}]}, {"details": [{"Name": "Carol"}]}, {"details": [{}]} ]); { "acknowledged": true, "insertedIds": [ ObjectId("5e84b3cfb0f3fa88e22790d1"), ...
Read MoreDisplay the undefined and exact MongoDB document records
To display undefined and exact MongoDB document records, use the forEach() method with printjson(). The forEach() callback accepts two parameters: the document and the index, allowing you to display either the actual documents or undefined values. Syntax db.collection.find({}).forEach((document, index) => { printjson(document); // Display documents printjson(index); // Display undefined }); Sample Data db.demo496.insertMany([ { "Name": "David", "CountryName": "US" }, { "Name": "John", "CountryName": "AUS" }, { "Name": "Robert", ...
Read MoreUpdate only a single MongoDB document without deleting any date
To update only a single document in MongoDB, use the updateOne() method. This method updates the first document that matches the specified filter criteria and preserves all existing data except for the fields being updated. Syntax db.collection.updateOne( { "field": "matchValue" }, { $set: { "fieldToUpdate": "newValue" } } ); Create Sample Data Let us create a collection with documents − db.demo495.insertMany([ {"FirstName":"Chris", "Age":19}, {"FirstName":"David", "Age":21}, {"FirstName":"Bob", "Age":26}, {"FirstName":"John", ...
Read MoreUpdate elements inside an array in MongoDB?
To update elements inside an array in MongoDB, use the $set operator combined with the $ positional operator. The positional operator identifies the array element that matches the query condition and allows you to update specific fields within that element. Syntax db.collection.update( { "arrayField.field": "matchValue" }, { $set: { "arrayField.$.fieldToUpdate": "newValue" } } ); Create Sample Data db.demo494.insertOne({ "CollegeDetails": [ { ...
Read MoreMake nested queries in MongoDB 4 to fetch a specific document
To make nested queries in MongoDB 4 to fetch a specific document, use dot notation to traverse through nested objects and arrays. This allows you to query deeply nested fields within documents. Syntax db.collection.find({ "parentField.childField.nestedField": "value" }); Sample Data Let us first create a collection with nested documents ? db.demo492.insertMany([ { "ProductDetails": { "StockDetails": [ ...
Read MoreHow to match date with MongoDB $match?
To match date in MongoDB, use $match operator within the aggregation pipeline. The $match stage filters documents based on date criteria using comparison operators like $gte, $lte, or $eq. Syntax db.collection.aggregate([ { $match: { "dateField": { "$operator": ISODate("YYYY-MM-DDTHH:mm:ss.sssZ") } ...
Read MoreMongoDB query to fetch random value using Map Reduce concept.
To fetch random values using Map Reduce in MongoDB, use the mapReduce() method combined with Math.random() to emit documents based on a probability threshold. Syntax db.collection.mapReduce( function() { if (Math.random() < threshold) emit(this._id, this); }, function(key, values) { return values; }, { out: "outputCollection" } ); Sample Data db.demo651.insertMany([ {Value: 10}, {Value: 20}, {Value: 30}, {Value: 40}, {Value: 50}, ...
Read MoreQuerying only the field name and display only the id in MongoDB?
To query only specific fields in MongoDB, use projection to control which fields appear in the result. Set field values to 1 to include or 0 to exclude them from the output. Syntax db.collection.find(query, projection); // Include specific fields db.collection.find({}, {fieldName: 1}); // Exclude specific fields db.collection.find({}, {fieldName: 0}); Sample Data db.demo650.insertMany([ {_id: 101, details: {Name: "Chris", Age: 21}}, {_id: 102, details: {Name: "Bob", Age: 22}}, {_id: 103, details: {Name: "Sam", Age: 20}}, ...
Read MoreMongoDB aggregation group and remove duplicate array values?
To group documents and remove duplicate values from arrays in MongoDB, use the aggregation framework with $unwind to deconstruct arrays and $addToSet within $group to collect unique values. Syntax db.collection.aggregate([ { $unwind: "$arrayField" }, { $group: { _id: "$groupByField", arrayField: { $addToSet: "$arrayField" }, otherField: { $first: "$otherField" } }} ]); Sample Data db.demo649.insertMany([ ...
Read MoreMongoDB aggregation to combine or merge fields and then count?
To combine or merge fields and then perform count, use $group along with $sum and $sort. This aggregation approach groups documents by field values and counts occurrences in each group. Syntax db.collection.aggregate([ { $group: { "_id": "$fieldName", "COUNT": { $sum: 1 } } }, { $sort: { "COUNT": -1 } }, { $limit: n } ]); Sample Data db.demo647.insertMany([ {"Subject": "MySQL"}, {"Subject": "MongoDB"}, {"Subject": "MySQL"}, ...
Read More