MongoDB 3.4 has brought out a number of new, very useful aggregation operators for both recursive search ($graphLookup), and faceted search ($bucket, $bucketAuto, $facet, $sortByCount).

See below for a brief explanation of each new operator. And of course, both IntelliShell and the Studio 3T aggregation builder fully support the new additions.

OPERATORDESCRIPTION
$bucketCategorizes incoming documents into groups, called buckets, based on a specified expression and bucket boundaries.
$bucketAutoCategorizes incoming documents into a specific number of groups, called buckets, based on a specified expression. Bucket boundaries are automatically determined in an attempt to evenly distribute the documents into the specified number of buckets.
$facetProcesses multiple aggregation pipelines within a single stage on the same set of input documents. Enables the creation of multi-faceted aggregations capable of characterizing data across multiple dimensions, or facets, in a single stage.
$sortByCountCategorizes or groups incoming documents by a specified expression to compute the count for each group. Output documents are sorted in descending order by the count.
$graphLookupPerforms a recursive search on a collection. To each output document, adds a new array field that contains the traversal results of the recursive search for that document.

Studio 3T not only fully supports the MongoDB aggregation pipeline, it supports a whole range of functions designed to decrease the time it takes for you to execute your tasks. If you would like to experience these time-saving features then start your 14-day free trial. And if you’re on your smartphone, or don’t have time to download now, simply fill in the form below and we will email you a link for later.


No time to try Studio 3T now?

Enter your email to receive a download link for later.