SqlQueryParams
Interface
Query parameter which supports SQL.
Properties
| Property | Type | Notes |
|---|---|---|
string[] | One or more | |
string[] | One or more | |
string[] | The list of fields to be included in the returned result set. | |
number | Page number starts from 1, not 0. | |
number | Page size. | |
string | A where clause for the query. |
orderByFields
orderByFields: string[]One or more jimuFieldName by which the features/records will be ordered.
Use ASC for ascending and DESC for descending. The following fields are used to control the ordering.
orderByFields is set to ASC (ascending order) by default if
outFields
outFields: string[]The list of fields to be included in the returned result set.
groupByFieldsForStatistics: string[]One or more
jimuFieldNameby which the values will be grouped for calculating the statistics.