Order filter - Loopback Next

An order filter specifies how to sort the results: ascending (ASC) or descending (DESC) based on the specified property.

Order by one property:

<pre> {order: 'propertyName <ASC|DESC>'} </pre>

Order by two or more properties:

<pre> {order: ['propertyName <ASC|DESC>', 'propertyName <ASC|DESC>',...]} </pre>

Where:

propertyName is the name of the property (field) to sort by.
<ASC|DESC> signifies either ASC for ascending order or DESC for descending order.

Order by one property:

<pre> ?filter[order]=propertyName%20<ASC|DESC> </pre>

Order by two or more properties:

<pre> ?filter[order][0]=propertyName <ASC|DESC>&filter[order][1]=propertyName <ASC|DESC>... </pre>

Where:

propertyName is the name of the property (field) to sort by.
<ASC|DESC> signifies either ASC for ascending order or DESC for descending order.

You can also use stringified JSON format in a REST query.

{% include note.html content="Configure default ordering in default scope. " %}

Return the three most expensive items, sorted by the price property:

{% include code-caption.html content="Node.js API" %}

await itemRepository.find({
  order: 'price DESC',
  limit: 3,
});

{% include code-caption.html content="REST" %}

/items?filter[order]=price%20DESC&filter[limit]=3

Or stringified JSON format:

/items?filter={"order":["price DESC"],"limit":3}