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 54 of 111
Is there any way in MongoDB to get the inner value of json data?
To get inner values of JSON data in MongoDB, use the find() method along with dot notation to access nested fields within documents and arrays. Syntax db.collection.find( {}, { "outerField.innerField": 1, "_id": 0 } ); Sample Data db.demo235.insertOne({ "id": 101, "details": [ { "Name": "Chris Brown", ...
Read MoreUsing MongoDB Aggregate and GroupBy to get the frequency of name record
To get the frequency of name records in MongoDB, use the aggregation framework with $group stage to group documents by name and count occurrences using $sum. Syntax db.collection.aggregate([ { $group: { _id: "$fieldName", Frequency: { $sum: 1 } } } ]); Create Sample Data db.demo232.insertMany([ ...
Read MoreChange a unique index to a sparse unique index in MongoDB?
To change a unique index to a sparse unique index in MongoDB, you must drop the existing index and recreate it with the sparse: true option. MongoDB doesn't support modifying index properties directly. Syntax // Drop existing unique index db.collection.dropIndex("indexName"); // Create sparse unique index db.collection.createIndex({"field": 1}, {unique: true, sparse: true}); Example: Converting Unique to Sparse Unique Index Step 1: Create Initial Unique Index db.demo229.createIndex({"ClientName": 1}, {unique: true}); { "createdCollectionAutomatically": true, "numIndexesBefore": 1, "numIndexesAfter": 2, ...
Read MoreFind document in MongoDB where at least one item from an array is not in the other?
To find documents in MongoDB where at least one item from an array is not in another specified set, use the $nin operator or regex patterns to match arrays containing elements outside your target list. Syntax // Using $nin operator db.collection.find({ "arrayField": { $nin: ["value1", "value2"] } }); // Using regex for negative lookahead db.collection.find({ "arrayField": /^(?!value1|value2)/ }); Sample Data db.demo228.insertMany([ { "Subjects": ["MongoDB", "Java"] }, { "Subjects": ["MongoDB", "Java", "MySQL"] }, { "Subjects": ["Python", "JavaScript"] } ]); ...
Read MoreUpdating a set of documents from a list of key value pairs in MongoDB
To update multiple documents from a list of key-value pairs in MongoDB, use bulk operations with initializeUnorderedBulkOp() to efficiently process multiple updates in a single operation. Syntax var bulkUpdateValue = [{"_id": "key1", "field": "value1"}, {"_id": "key2", "field": "value2"}]; var bulkUpdate = db.collection.initializeUnorderedBulkOp(); for (var i = 0; i < bulkUpdateValue.length; i++){ var updateItem = bulkUpdateValue[i]; bulkUpdate.find({_id: updateItem._id}).update({$set: {field: updateItem.field}}); } bulkUpdate.execute(); Sample Data db.demo227.insertMany([ {"_id": "101", "Name": "Chris"}, {"_id": "102", "Name": "Bob"} ]); { ...
Read MoreMongoDB query to display all the values excluding the id?
To exclude the _id field from MongoDB query results, use the $project operator in an aggregation pipeline. The $project stage allows you to include or exclude fields, suppress the _id field, and rename existing fields. Syntax db.collection.aggregate([ { $project: { _id: 0, field1: 1, field2: 1 } } ]); Sample Data db.demo226.insertMany([ { "Name": "Chris", "Age": 21 }, { "Name": "Bob", "Age": 20 }, { "Name": "David", "Age": 22 } ]); { ...
Read MoreHow to compare multiple properties in MongoDB?
To compare multiple properties in MongoDB, you can use the $where operator or the $expr operator. The $where allows JavaScript expressions to compare fields, while $expr uses aggregation expressions for better performance. Syntax // Using $where (JavaScript expression) db.collection.find({ $where: "this.field1 > this.field2" }); // Using $expr (Aggregation expression - Recommended) db.collection.find({ $expr: { $gt: ["$field1", "$field2"] } }); Sample Data db.demo223.insertMany([ {"Scores": [56, 78]}, {"Scores": [88, 45]}, {"Scores": [98, 79]} ]); { ...
Read MoreMongoDB query to add new array element in document
To add new array element in a MongoDB document, use the $ positional operator along with $set in an update operation. This allows you to add a new field to a specific element within an array. Syntax db.collection.update( {"arrayField.existingField": "matchValue"}, {"$set": {"arrayField.$.newField": "newValue"}} ); Sample Data db.demo222.insertOne({ "details": [ { "StudentName": "Chris", ...
Read MoreMongoDB regular expression to fetch record with specific name "John", instead of "john
To fetch records with a specific case-sensitive name using MongoDB regular expressions, use the exact pattern match syntax /searchWord/. By default, MongoDB regex is case-sensitive, so /John/ will match "John" but not "john". Syntax db.collection.find({"field": /exactPattern/}); Sample Data db.demo221.insertMany([ {"Details": {"StudentName": "Chris", "StudentAge": 21}}, {"Details": {"StudentName": "John", "StudentAge": 20}}, {"Details": {"StudentName": "Bob", "StudentAge": 22}}, {"Details": {"StudentName": "john", "StudentAge": 24}} ]); { "acknowledged": true, "insertedIds": [ ...
Read MoreGet all embedded documents with "isMarried" status in a MongoDB collection
To get all embedded documents with specific fields in MongoDB, use the $project aggregation operator. This allows you to extract and display specific fields from embedded documents. Syntax db.collection.aggregate([ { $project: { "fieldName": "$embeddedDocument.fieldName", "anotherField": "$embeddedDocument.anotherField" } } ]); Sample Data db.demo220.insertMany([ ...
Read More