Navigation
This version of the manual is no longer supported.

db.collection.distinct()

db.collection.distinct()

The db.collection.distinct() method finds the distinct values for a specified field across a single collection and returns the results in an array. The method accepts the following argument:

Parameters:
  • field (string) – Specifies the field for which to return the distinct values.
  • query (document) – Specifies the selection query to determine the subset of documents from which to retrieve the distinct values.

Note

Consider the following examples of the db.collection.distinct() method:

  • Return an array of the distinct values of the field ord_dt from all documents in the orders collection:

    db.orders.distinct( 'ord_dt' )
    
  • Return an array of the distinct values of the field sku in the subdocument item from all documents in the orders collection:

    db.orders.distinct( 'item.sku' )
    
  • Return an array of the distinct values of the field ord_dt from the documents in the orders collection where the price is greater than 10:

    db.orders.distinct( 'ord_dt',
                        { price: { $gt: 10 } }
                      )