widgetFirst - prioritizes the widget filters over the provided filters in case of filter conflicts by certain attributes.
codeFirst - prioritizes the provided filters over the widget filters in case of filter conflicts by certain attributes.
codeOnly - applies only the provided filters and completely ignores the widget filters.

If not specified, the default strategy is codeFirst.

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.

includeDashboardFilters

includeDashboardFilters?: boolean

Boolean flag whether to include dashboard filters in the widget's filters and highlights

If not specified, the default value is false.

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, the total is returned as rowCount in the query state (QueryByWidgetIdState.rowCount) and 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.

Not supported for pivot table widgets.

If not specified, the default value is false

offset

offset?: number

Offset of the first row to return

If not specified, the default value is 0

onBeforeQuery

onBeforeQuery?: (jaql) => any

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

Note: In React, wrap this function in useCallback hook to avoid triggering query execution on each render.

const onBeforeQuery = useCallback((jaql) => {
  // modify jaql here
  return jaql;
}, []);

Parameters

Parameter	Type
`jaql`	`any`

Returns

any

widgetOid

widgetOid: string

Identifier of the widget