Documentation · Reading data

`FindSorted`

The rows meeting the conditions, sorted on a field ("asc" or "desc", empty last), then the first "limit" ones (500 at most). A number right after the limit skips that many rows (paging). Sorting covers all rows, not only the first 500.

Allowed in a filter

Syntax

FindSorted(table, sort_field, direction, limit, [condition…])

Parameters

Parameter	Type	Details
`table`	text	required
`sort_field`	text	required
`direction`	text	required
`limit`	number	required
`condition`	any value	optional, repeatable

Returns

list

Example

FindSorted("Bons", "date", "desc", 50, "statut", "=", "A traiter")

In the same family

Find
FindOne
GetRow