Skip to main content

Updating Chart Data

  • Updated
Not yet followed by anyone

Updating Chart Data

To request new data from the Info application server and replace the data, if any, in the chart, use this chart object method:

    rdUpdateChartData([requestParams])
where requestParams is:
  • An optional JavaScript object,
  • Provided to the report definition as Request variables when the function is called,
  • Where the property name is the Request variable name and the property value is Request variable value.

Here's an example using the chart object from Getting the Chart Object:

var requestParams = {};
requestParams.OrderDate = "01/01/2015";
requestParams.ProductCategory = "Seafood";
myChartObject.rdUpdateChartData(requestParams);

In a hypothetical report definition using this script, the Chart Canvas Chart element would have a child datalayer that made use of the request variables by using tokens. For example, using DataLayer.SQL, they might be used in a query like this:

SELECT * FROM Orders WHERE OrderDate = '@Request.OrderDate~' AND Category = '@Request.ProductCategory~'

The query would return a result set in which the OrderDate column value = "01/01/2015" and the Category column value = "Seafood". The chart series would be updated with that result set. The same behavior applies whether the datalayer is a child of the Chart Canvas Chart element or a child of one of the Series elements.

Related articles