Back to DocumentationMQL Documentation

$lte

The `$lte` operator retrieves documents where the value of a field is less than or equal to a specified value.

Syntax

{ field: { $lte: <value> } }

Parameters

fieldstringrequired

The field to be compared

valuenumberrequired

The value to compare against

Examples

Find stores with sales <= $35,000

To find stores with sales less than or equal to $35,000, run a query using $lte on the sales.totalSales field.

Query:

db.stores.find({
    "sales.totalSales": { $lte: 35000 }
}, { _id: 1 }, { limit: 1 })

Output:

[{ "_id": "e6895a31-a5cd-4103-8889-3b95a864e5a6" }]

Find stores with 12 or fewer full-time staff

To find stores with 12 or fewer full-time staff, run a query using $lte on the nested fullTime field.

Query:

db.stores.find({
    "staff.totalStaff.fullTime": { $lte: 12 }
}, { name: 1, "staff.totalStaff.fullTime": 1 }, { limit: 1 })

Output:

[{ "_id": "e6895a31-a5cd-4103-8889-3b95a864e5a6", "name": "VanArsdel, Ltd. | Picture Frame Store - Port Clevelandton", "staff": { "totalStaff": { "fullTime": 6 } } }]

Related