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 97 of 111
Getting a distinct aggregation of an array field across indexes
To get a distinct aggregation of an array field across indexes in MongoDB, use the distinct() method on the array field. MongoDB will automatically utilize any existing index on that field to optimize the operation. Syntax db.collection.distinct("arrayFieldName") Sample Data Let's create a collection with documents containing array fields ? db.distinctAggregation.insertMany([ { "UserName": "Larry", "UserPost": ["Hi", "Hello"] }, { ...
Read MoreGet only the FALSE value with MongoDB query
To get only the documents with FALSE values from a boolean field in MongoDB, use the find() method with a query condition that matches the false value directly or uses comparison operators. Syntax db.collection.find({ "fieldName": false }); // OR db.collection.find({ "fieldName": { "$ne": true } }); Sample Data Let us first create a collection with documents having an isEnable field with TRUE or FALSE values ? db.translateDefinitionDemo.insertMany([ { "_id": 10, "StudentName": "Larry", "isEnable": true }, { "_id": 20, "StudentName": "Chris", "isEnable": false }, ...
Read MoreHow to get all the collections from all the MongoDB databases?
To get all the collections from all MongoDB databases, you need to first retrieve all databases and then iterate through each database to get their collections. Syntax // Step 1: Get all databases switchDatabaseAdmin = db.getSiblingDB("admin"); allDatabaseName = switchDatabaseAdmin.runCommand({ "listDatabases": 1 }).databases; // Step 2: Iterate through databases to get collections allDatabaseName.forEach(function(databaseName) { db = db.getSiblingDB(databaseName.name); collectionName = db.getCollectionNames(); // Process collections as needed }); Method 1: Get All Database Names First, let us get all the databases using the admin ...
Read MoreCan I get the first item in a Cursor object in MongoDB?
Yes, you can get the first item in a cursor object in MongoDB using the findOne() method or by applying the limit(1) method to a cursor. Syntax // Method 1: Using findOne() db.collection.findOne(); db.collection.findOne({condition}); // Method 2: Using find().limit(1) db.collection.find().limit(1); Sample Data db.getFirstItemDemo.insertMany([ {"CustomerName": "Chris", "CustomerAge": 28}, {"CustomerName": "Larry", "CustomerAge": 26}, {"CustomerName": "Robert", "CustomerAge": 29}, {"CustomerName": "David", "CustomerAge": 39} ]); { "acknowledged": true, "insertedIds": [ ...
Read MoreMongoDB query to return only embedded document?
While MongoDB doesn't return only embedded documents directly, you can use projection to return specific fields and the $elemMatch operator to filter array elements that match certain conditions. Syntax db.collection.find( { "arrayField.nestedField": { $gte: value } }, { "arrayField": { $elemMatch: { "nestedField": { $gte: value } } } } ); Sample Data db.queryToEmbeddedDocument.insertOne({ "UserName": "Larry", "PostDetails": [ { "UserMessage": "Hello", "UserLikes": 8 }, ...
Read MoreSearch a string with special characters in a MongoDB document?
To search a string with special characters in MongoDB document, you can use backslash (\) to escape the special character in a regular expression. Here, we have special character $ in our string. Syntax db.collection.find({ "fieldName": /.*\specialCharacter.*/i }); Sample Data Let us first create a collection with documents ? db.searchDocumentWithSpecialCharactersDemo.insertMany([ { "UserId": "Smith$John123", "UserFirstName": "John", "UserLastName": "Smith" ...
Read MoreCan we use NOT and AND together in MongoDB?
Yes, we can use NOT and AND together in MongoDB. MongoDB doesn't have direct NOT and AND operators, but we achieve this using $or and $ne operators following De Morgan's law: NOT (X AND Y) = NOT X OR NOT Y. Syntax db.collection.find({ "$or": [ {"field1": {"$ne": "value1"}}, {"field2": {"$ne": "value2"}} ] }); Sample Data db.NotAndDemo.insertMany([ {"StudentName": "John", "StudentCountryName": "US"}, {"StudentName": ...
Read MoreHow to remove document on the basis of _id in MongoDB?
To remove a document based on its _id in MongoDB, use the remove() method with the ObjectId as the matching criteria. Each document has a unique _id field that serves as the primary key. Syntax db.collectionName.remove({"_id": ObjectId("yourObjectId")}); Sample Data Let us first create a collection with sample documents ? db.removeDocumentOnBasisOfId.insertMany([ {"UserName": "Larry", "UserAge": 23, "UserCountryName": "US"}, {"UserName": "Sam", "UserAge": 21, "UserCountryName": "UK"}, {"UserName": "Chris", "UserAge": 24, "UserCountryName": "US"}, {"UserName": "Robert", "UserAge": 26, "UserCountryName": "UK"}, ...
Read MoreIncrement a value in a MongoDB nested object?
To increment a value in a MongoDB nested object, use the $inc operator combined with the $ positional operator to target the specific nested element and increment its numeric value. Syntax db.collection.update( {"nestedArray.field": "matchValue"}, { $inc: { "nestedArray.$.fieldToIncrement": incrementValue } } ); Create Sample Data Let us create a collection with a document containing nested array objects ? db.incrementValueDemo.insertOne({ "StudentName": "Larry", "StudentCountryName": "US", "StudentDetails": [ ...
Read MoreInserting the current datetime in MongoDB?
To insert current datetime in MongoDB, use new Date() during insertion or $setOnInsert with upsert operations. MongoDB stores dates in ISODate format with UTC timezone. Syntax // Direct insertion db.collection.insertOne({ fieldName: new Date() }); // With upsert operation db.collection.update( { _id: value }, { $set: { field1: "value" }, $setOnInsert: { dateField: new Date() } }, { upsert: true } ); Sample Data db.addCurrentDateTimeDemo.insertMany([ { "StudentName": "John", "StudentAdmissionDate": new Date("2012-01-21") }, { ...
Read More