Parameters
prestd uses query string to apply filtering, sorting, paginating, and etc to api queries.
Filters
HTTP method GET
query string | Description |
---|---|
| the api return is paged, this parameter sets which page you want |
| delimits the number of records per page, default |
| Limit fields list on result - sql ansii standard |
| Count per field - |
| Query string |
| Set API render syntax, supported: |
|
|
|
|
|
|
| Filter by field, you can set as many query parameters as needed |
Functions support
Used to perform data aggregation(grouping and selection)
name | Use in request |
---|---|
SUM |
|
AVG |
|
MAX |
|
MIN |
|
STDDEV |
|
VARIANCE |
|
SELECT
with function:
GROUP BY
with function:
Operators
Uses these operators in various filter applications
Name | Description |
---|---|
| Matches values that are equal to a specified value |
| Matches values that are greater than a specified value |
| Matches values that are greater than or equal to a specified value |
| Matches values that are less than a specified value |
| Matches values that are less than or equal to a specified value |
| Matches all values that are not equal to a specified value |
| Matches any of the values specified in an array |
| Matches none of the values specified in an array |
| Matches if field is null |
| Matches if field is not null |
| Matches if field is true |
| Matches if field is not true |
| Matches if field is false |
| Matches if field is not false |
| Matches always cover the entire string |
| Matches case-insensitive always cover the entire string |
| Matches results without the entire string |
| Matches case-insensitive results without the entire string |
| Is left argument an ancestor of right (or equal)? |
| Is left argument a descendant of right (or equal)? |
| Does ltree match lquery? |
| Does ltree match ltxtquery? |
Last updated