MongoLink`
MongoLink`

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

Examples

Basic Examples  (1)

Connect to a client:

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":

Destroy the collection that was created:

Wolfram Research (2018), MongoCollectionDistinct, Wolfram Language function, https://reference.wolfram.com/language/MongoLink/ref/MongoCollectionDistinct.html.

Text

Wolfram Research (2018), MongoCollectionDistinct, Wolfram Language function, https://reference.wolfram.com/language/MongoLink/ref/MongoCollectionDistinct.html.

BibTeX

@misc{reference.wolfram_2021_mongocollectiondistinct, author="Wolfram Research", title="{MongoCollectionDistinct}", year="2018", howpublished="\url{https://reference.wolfram.com/language/MongoLink/ref/MongoCollectionDistinct.html}", note=[Accessed: 29-November-2021 ]}

BibLaTeX

@online{reference.wolfram_2021_mongocollectiondistinct, organization={Wolfram Research}, title={MongoCollectionDistinct}, year={2018}, url={https://reference.wolfram.com/language/MongoLink/ref/MongoCollectionDistinct.html}, note=[Accessed: 29-November-2021 ]}

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