Interface ExecuteQueryParams

Parameters for data query execution.

Properties

beforeQuery

beforeQuery?: (jaql) => any

Sync or async callback that allows to modify the JAQL payload before it is sent to the server.

Parameters

Returns

any

count

count?: number

Number of rows to return in the query result

If not specified, the default value is 20000

dataSource

dataSource?: DataSource

Data source the query is run against - e.g. Sample ECommerce

If not specified, the query will use the defaultDataSource specified in the parent Sisense Context.

dimensions

dimensions?: Attribute[]

Dimensions of the query

filters

filters?: FilterRelations | Filter[]

Filters that will slice query results

highlights

highlights?: Filter[]

Highlight filters that will highlight results that pass filter criteria.

NOTE that highlight filters in the "Include all" state are silently omitted from the query. To clear a highlight, remove it from the array.

includeRowCount Beta

includeRowCount?: boolean

Boolean flag whether to include the total row count of the query result, ignoring the count and offset paging.

When enabled, an additional row count query is sent to the server alongside the data query, and the total is returned in ExecuteQueryResult.rowCount. The retrieved total is reused for subsequent pages of the same query.

Row count feature requires a Sisense instance version of 2026.3.0 or greater. On older versions, the query still succeeds and rowCount stays undefined.

If not specified, the default value is false

measures

measures?: Measure[]

Measures of the query

offset

offset?: number

Offset of the first row to return

If not specified, the default value is 0

ungroup

ungroup?: boolean

Boolean flag whether to include ungroup: true in non-aggregated JAQL queries.

This improves computation and performance of querying tables when no aggregation is needed

If not specified, the default value is false