runQuery

runQuery(query:Query Object)

Invoke this method on a pivot table instance. It takes a Query Object as an argument and runs it. The Query Object contains a slice with rows, columns, measures, and reportFilters.

Use it if you need to:

• reorganize the hierarchies on the grid.
• compose a new report that is based on the current data.

Parameters

Name	Type	Description
query	Query Object	Contains rows, columns, measures, and reportFilters from a Slice Object.

Example

Suppose you have a pivot table with the following report:

var pivot = new WebDataRocks({
  container: "wdr-component",
  toolbar: true,
  report: {
    dataSource: {
      filename: "https://cdn.webdatarocks.com/data/data.csv"
    },
    slice: {
      rows: [
        {
          uniqueName: "Category"
        }
      ],
      columns: [
        {
          uniqueName: "Measures"
        },
        {
          uniqueName: "Country"
        }
      ],
      measures: [
        {
          uniqueName: "Price",
          aggregation: "sum"
        }
      ]
    }
  }
});

If you want to rearrange the hierarchies in a slice dynamically with code, define the following slice and pass it as an argument to the runQuery() method:

var slice = {
  rows: [
    {
      uniqueName: "Country"
    }
  ],
  columns: [
    {
      uniqueName: "Category"
    }
  ],
  measures: [
    {
      uniqueName: "Price",
      aggregation: "sum"
    }
  ]
};

webdatarocks.runQuery(slice);

Check out more details in the CodePen demo.

See also

• Slice Object
• getReport()
• setReport()