Advanced Queries

When querying a Collection, you can use special commands to create a more advanced query.

Deployd supports all of MongoDB's conditional operators; only the common operators and Deployd's custom commands are documented here.

When using an advanced query in REST, you must pass JSON as the query string, for example:

GET /posts?{"likes": {"$gt": 10}}

If you are using dpd.js, this will be handled automatically.

Comparison ($gt, $lt, $gte, $lte)

Compares a Number property to a given value.

$gt - Greater than
$lt - Less than
$gte - Greater than or equal to

$lte - Less than or equal to

  //Finds all posts with more than 10 likes
  {
  	likes: {$gt: 10}
  }

$ne (Not Equal)

The $ne command lets you choose a value to exclude.

// Get all posts except those posted by Bob
{
	author: {$ne: "Bob"}
}

$in

The $in command allows you to specify an array of possible matches.

// Get articles in the "food", "business", and "technology" categories
{
	category: {$in: ["food", "business", "technology"]}
}

Query commands

Query commands apply to the entire query, not just a single property.

$sort

The $sort command allows you to order your results by the value of a property. The value can be 1 for ascending sort (lowest first; A-Z, 0-10) or -1 for descending (highest first; Z-A, 10-0)

// Sort posts by likes, descending
{
	$sort: {likes: -1}
}

$limit

The $limit command allows you to limit the amount of objects that are returned from a query. This is commonly used for paging, along with $skip.

// Return the top 10 scores
{
	$sort: {score: -1}
	$limit: 10
}

$skip

The $skip command allows you to exclude a given number of the first objects returned from a query. This is commonly used for paging, along with $limit.

// Return the third page of posts, with 10 posts per page
{
	$skip: 20
	$limit: 10
}

2.0 KiB Raw Permalink Blame History