MongoCollectionDistinct
MongoCollectionDistinct[MongoCollection[…],f]
obtain a list of distinct values for the field in the collection.
MongoCollectionDistinct[MongoCollection[…],field,query]
obtain a list of distinct values for the field for documents matching query.
Details and Options
- To use MongoCollectionDistinct, you first need to load MongoLink using Needs["MongoLink`"].
- MongoCollectionDistinct returns a List.
- MongoCollectionDistinct corresponds to the db.collection.distinct.
Examples
Basic Examples (1)
Connect to a new "WolframTestDistinct" collection in the "WolframTestDB" database:
Find the list of distinct items in the "dept" field:
Find the list of distinct items in the "sku" subfield of the "item" field:
Find the list of distinct items in the "sku" subfield of the "item" field from the set of documents whose "dept" field has value "A":
Text
Wolfram Research (2018), MongoCollectionDistinct, Wolfram Language function, https://reference.wolfram.com/language/MongoLink/ref/MongoCollectionDistinct.html.
CMS
Wolfram Language. 2018. "MongoCollectionDistinct." Wolfram Language & System Documentation Center. Wolfram Research. https://reference.wolfram.com/language/MongoLink/ref/MongoCollectionDistinct.html.
APA
Wolfram Language. (2018). MongoCollectionDistinct. Wolfram Language & System Documentation Center. Retrieved from https://reference.wolfram.com/language/MongoLink/ref/MongoCollectionDistinct.html