#MONGODB COMPASS DISTINCT HOW TO#

The unwind is performed to create a unique document for each element in the target array, which enables the addToSet operator in the group stage to then capture the genres as distinct elements. Indexes can also cover db.collection.distinct() operations. You can do this via aggregation framework in Compass, using unwind and group. When possible, db.collection.distinct() operations can use indexes. Behavior In a sharded cluster, the distinct command may return orphaned documents.

Refer to the specific driver documentation. Additionally, many MongoDB drivers provide a wrapper method. If the value of the specified field is an array, db.collection.distinct() considers each element of the array as a separate value.įor instance, if a field has as its value, 1 ], then db.collection.distinct() considers 1,, and 1 as separate values. MongoDB Compass securely stores sensitive information entered in the connection form using an API that is specific to your operating system. MongoDB also provides the shell wrapper method db.collection.distinct () for the distinct command. Retrieve the restaurants data from here Behavior It has its own MongoDB Query Language(MQL) that contains an. The method returns the following array of distinct zipcode values: [ MongoDB being a NoSQL database does not follow the retrieval mechanism of traditional databases.

#MONGODB COMPASS DISTINCT HOW TO#

Sample document in the restaurants collection: MongoDB: How to Count Distinct Values in Field You can use the following methods to count the distinct values in a specific field in MongoDB: Method 1: Find List of Distinct Values db.collection. The field for which to return distinct values.Ī query that specifies the documents from which to retrieve the distinct values.

Mongodb compass distinct