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. |
groupByFieldsForStatistics optional
orderByFields optional
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 optional
outFields: string[]The list of fields to be included in the returned result set.
page optional
page: numberPage number starts from 1, not 0.
pageSize optional
pageSize: numberPage size.
where optional
where: stringA where clause for the query.
groupByFieldsForStatistics: string[]One or more
jimuFieldNameby which the values will be grouped for calculating the statistics.