Back to DocumentationMQL Documentation

$natural

Controls the order in which documents are returned by specifying natural order (insertion order) or reverse natural order.

Syntax

{ $natural: <1 or -1> }

Parameters

ordernumberrequired

1 for natural order (insertion order), -1 for reverse natural order

Examples

Sort by insertion order

Return documents in the order they were inserted into collection

Query:

db.logs.find().sort({ $natural: 1 })

Output:

Log documents returned in natural insertion order (oldest first)

Reverse insertion order

Return documents in reverse insertion order (newest first)

Query:

db.events.find().sort({ $natural: -1 })

Output:

Event documents returned in reverse natural order (newest first)

Related