DevExtreme jQuery - CustomStore LoadOptions
This object is used to specify settings according to which the server should process data. More often these settings are passed as a parameter to the load function and depend on the operations (paging, filtering, sorting, etc.) that you have enabled in the DataSource or widget.
See Also
customQueryParams
An object for storing additional settings that should be sent to the server. Relevant to the ODataStore only.
expand
An array of strings that represent the names of navigation properties to be loaded simultaneously with the ODataStore.
filter
Defines filtering parameters. Possible variants:
Binary filter
[ "field", "=", 3 ]
Unary filter
[ "!", [ "field", "=", 3 ] ]
Complex filter
[ [ "field", "=", 10 ], "and", [ [ "otherField", "<", 3 ], "or", [ "otherField", ">", 11 ] ] ]
See Also
group
Defines grouping levels to be applied to the data. This object can have the following fields:
- selector: String
The field name to group by. - desc: Boolean
Defines the selector field's descending sort order. - isExpanded: Boolean
Defines whether the group's data objects should be returned instead of grouping data. Relevant only for the last group. - groupInterval: Number or String
A numeric value groups data in ranges of the given length. A string value applies only to dates and can be "year", "quarter", "month", "day", "dayOfWeek", "hour", "minute" and "second".
groupSummary
A group summary expression. Used with the group setting.
Contains group summary definitions with the following structure, where summaryType can be "sum", "avg", "min", "max" or "count":
{ selector: "field", summaryType: "sum" }
When this option is specified, each data object should have a summary array that contains the resulting values in the same order as the summary definitions.
parentIds
The IDs of the rows being expanded. Relevant only when the CustomStore is used in the TreeList widget.
Array<any>
If the TreeList's expandedRowKeys are set, the parentIds array contains them and the root ID. Otherwise, the array contains only the ID of the row being expanded.
requireGroupCount
Indicates whether a top-level group count is required. Used in conjunction with the filter, take, skip, requireTotalCount, and group settings.
requireTotalCount
When this option is true, the store expects the result to contain the totalCount field, which is the total data object count in the resulting data set. This count should reflect the number of data items after filtering but disregard any take parameter used for the query.
searchExpr
Along with searchValue and searchOperation, this option defines a simple filtering condition.
searchOperation
A comparison operation. Can have one of the following values: "=", "<>", ">", ">=", "<", "<=", "startswith", "endswith", "contains", "notcontains", "isblank" and "isnotblank".
Along with searchValue and searchExpr, this option defines a simple filtering condition.
searchValue
Along with searchOperation and searchExpr, this option defines a simple filtering condition.
skip
The number of data objects to be skipped from the result set's start. In conjunction with take, used to implement paging.
take
The number of data objects to be loaded. In conjunction with skip, used to implement paging.
totalSummary
Contains summary definitions with the following structure, where summaryType can be "sum", "avg", "min", "max" or "count":
{ selector: "field", summaryType: "sum" }
When this option is specified, the store expects the result to have the summary array that contains the result values in the same order as the summary definitions.