A newer version of this page is available. Switch to the current version.

DevExtreme jQuery - CustomStore LoadOptions

This section describes the loadOptions object's fields.

Type:

Object

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.

Type:

Object

expand

An array of strings that represent the names of navigation properties to be loaded simultaneously with the ODataStore.

Type:

Object

filter

A filter expression.

Type:

Object

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

A group expression.

Type:

Object

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.

Type:

Object

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.

Type:

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.

Type:

Boolean

When this option is true, the result should contain the groupCount field. This field is the resulting data set's top-level group count.

requireTotalCount

Indicates whether the total count of data objects is needed.

Type:

Boolean

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

A data field or expression whose value is compared to the search value.

Type:

getter

|

Array<getter>

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".

Type:

String

Along with searchValue and searchExpr, this option defines a simple filtering condition.

searchValue

The current search value.

Type: any

Along with searchOperation and searchExpr, this option defines a simple filtering condition.

select

Type:

Object

skip

The number of data objects to be skipped from the result set's start. In conjunction with take, used to implement paging.

Type:

Number

sort

A sort expression.

Type:

Object

Defines sorting options. This object can have the following fields:

  • selector: String
    The field name to sort by.
  • desc: Boolean
    Defines the selector field's descending sort order.

take

The number of data objects to be loaded. In conjunction with skip, used to implement paging.

Type:

Number

totalSummary

A total summary expression.

Type:

Object

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.

userData

An object for storing additional settings that should be sent to the server.

Type:

Object