We have updated Flexmonster Software License Agreement, effective as of September 30, 2025 (list of changes)
All documentation

runQuery

runQuery(query: SliceObject)

[starting from version: 1.6]

Runs a query with specified rows, columns, measures and reportFilters from the SliceObject and displays the result data. Use this method to rearrange hierarchies on the axes or to compose a new report based on the current data source.

Parameters

Parameter/TypeDescription
query
SliceObject
A new slice. Can contain only rows, columns, measures, and reportFilters properties of the SliceObject.

Example

let slice = {
rows: [
{ uniqueName: "Country" }
],
columns: [
{ uniqueName: "Color" }
],
measures: [
{ uniqueName: "Price" }
]
};
pivot.runQuery(slice);

Open the example on JSFiddle.

See also

getReport
setReport