# Interface ExecutePivotQueryParams
Parameters for pivot data query execution.
# Properties
# Data Options
# columns
columns?: (
Attribute|PivotAttribute)[]
Dimensions for the columns of the pivot table
# 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.
# grandTotals
grandTotals?:
PivotGrandTotals
Options for grand totals
# rows
rows?: (
Attribute|PivotAttribute)[]
Dimensions for the rows of the pivot table
# values
values?: (
Measure|PivotMeasure)[]
Measures for the values of the pivot table
# Filtering
# filters
filters?:
FilterRelations|Filter[]
Filters that will slice query results
# highlights
highlights?:
Filter[]
Filters that will highlight query results
# Other
# beforeQuery
beforeQuery?: (
jaql) =>any
Sync or async callback that allows to modify the JAQL payload before it is sent to the server.
# Parameters
| Parameter | Type |
|---|---|
jaql | any |
# Returns
any