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 Nishtha Thakur
Page 9 of 40
How to print document value in MongoDB shell?
To print specific document values in MongoDB shell, use the forEach() method combined with the print() function. This allows you to extract and display individual field values from query results. Syntax db.collection.find(query, projection).forEach(function(document) { print(document.fieldName); }); Sample Data db.printDocumentValueDemo.insertMany([ {"InstructorName": "John Smith"}, {"InstructorName": "Sam Williams"}, {"InstructorName": "David Miller"} ]); { "acknowledged": true, "insertedIds": [ ObjectId("5cd6804f7924bb85b3f48950"), ...
Read MoreHow to get tag count in MongoDB query results based on list of names?
To get tag count in MongoDB query results based on a list of names, use the $in operator to match documents containing any of the specified names in an array field, then apply count() to get the total number of matching documents. Syntax db.collection.find({"arrayField": {$in: ["value1", "value2"]}}).count(); Sample Data db.tagCountDemo.insertMany([ {"ListOfNames": ["John", "Sam", "Carol"]}, {"ListOfNames": ["Bob", "David", "John"]}, {"ListOfNames": ["Mike", "Robert", "Chris"]}, {"ListOfNames": ["James", "Carol", "Jace"]} ]); { "acknowledged": true, ...
Read MoreDelete partial data in MongoDB?
To delete partial data in MongoDB, you can combine find(), skip(), and map() methods to select specific documents, then use remove() with the $in operator to delete them based on their IDs. Syntax var ids = db.collection.find({}, {_id: 1}).skip(N).toArray().map(function(doc) { return doc._id; }); db.collection.remove({_id: {$in: ids}}); Sample Data db.deleteDemo.insertMany([ {"Name": "John"}, {"Name": "Carol"}, {"Name": "Sam"}, {"Name": "David"}, {"Name": "Robert"}, {"Name": "Chris"}, ...
Read MoreSearch an array of hashes in MongoDB?
To search an array of hashes in MongoDB, use dot notation to access fields within the hash objects stored in the array. This allows you to query specific key-value pairs within nested hash structures. Syntax db.collection.find({ "arrayName.fieldName": "value" }) Sample Data db.searchAnArrayDemo.insertMany([ { _id: 1, "TechnicalDetails": [{ "Language": "MongoDB" }] }, { _id: 2, "TechnicalDetails": [{ "Language": "MySQL" }] }, { _id: 3, "TechnicalDetails": [{ "Language": "MongoDB" }] }, { _id: 4, "TechnicalDetails": [{ "Language": "MongoDB" }] ...
Read MoreQuery Array for 'true' value at index n in MongoDB?
To query an array for a true value at a specific index in MongoDB, use dot notation with the array field name followed by the index position. This allows you to check boolean values at exact array positions. Syntax db.collection.find({"arrayField.INDEX": true}); // Multiple index conditions db.collection.find({ $and: [ {"arrayField.INDEX1": true}, {"arrayField.INDEX2": true} ] }); Sample Data db.containsTrueValueDemo.insertOne({ "IsMarried": [true, false, true, true, true, true, ...
Read MoreAdd a field to an embedded document in an array in MongoDB?
To add a field to an embedded document in an array in MongoDB, use the $set operator combined with the $ positional operator and $elemMatch to target the specific array element. Syntax db.collection.update( { "arrayField": { $elemMatch: { "matchField": "value" } } }, { $set: { "arrayField.$.newField": "newValue" } } ); Sample Data Let us create a collection with documents ? db.addAFieldDemo.insertOne({ "ClientName": "Larry", "ClientCountryName": "US", "ClientOtherDetails": [ ...
Read MoreHow to get a specific object from array of objects inside specific MongoDB document?
To get a specific object from array of objects inside a MongoDB document, use the positional operator $ in the projection to return only the matched array element. Syntax db.collection.find( { "arrayField.subField": "matchValue" }, { "_id": 0, "arrayField.$": 1 } ); Sample Data Let us create a collection with documents − db.getASpecificObjectDemo.insertOne({ _id: 1, "CustomerName": "Larry", "CustomerDetails": { "CustomerPurchaseDescription": [ ...
Read MoreHow to search for documents based on the value of adding two properties in MongoDB?
To search for documents based on the value of adding two properties in MongoDB, use the aggregation framework with $add operator to calculate the sum and $match to filter results based on the calculated value. Syntax db.collection.aggregate([ { $project: { totalValue: { $add: ["$field1", "$field2"] } } }, { $match: { totalValue: { $operator: value } } } ]); Sample Data db.searchDocumentsDemo.insertMany([ {"Value1": 100, "Value2": 560}, {"Value1": 300, "Value2": 150}, {"Value1": 400, "Value2": ...
Read MoreMongoDB pull with positional operator?
The $pull operator combined with the positional operator ($) in MongoDB allows you to remove specific values from arrays within nested documents. Use $elemMatch to identify the target document and $ to reference the matched array element. Syntax db.collection.update( { "arrayField": { "$elemMatch": { "field": "matchValue" ...
Read MoreHow to check if a field in MongoDB is [] or {}?
To check if a field in MongoDB is an empty array [] or an empty object {}, you can use the $size operator for arrays and $eq operator for objects to identify these specific empty states. Syntax // Check for empty object {} db.collection.find({ "fieldName": {} }); // Check for empty array [] db.collection.find({ "fieldName": { $size: 0 } }); // Check for both empty array or empty object db.collection.find({ $or: [ { "fieldName": {} }, ...
Read More