Skip to end of metadata
Go to start of metadata


This feature is new in Ignition version 7.9.4
Click here to check out the other new features

Using the Named Query Data Source

Using the Named Query datasource is simple to configure provided you already have a Named Query created, and works in the same way that other Named Query bindings work. The Named Query report datasource will execute the selected Named Query on the Gateway, and can use the Report Parameters as it's parameters.

This data source supports Nested Queries.

Configuring a Named Query Data Source

First select a Named Query by clicking the  button next to the Path field. 


In the resulting list, select one of the configured named queries. The Named Query parameters will appear, along with a preview of the query. 


One-by-one, select each parameter, and then click the  button next to the Parameters table. This provides a popup of all report parameters that are available on the report. Select a Report parameter that will provide a value to the Named Query parameter. Once every parameter has a value, check the results in the Preview Panel. 


On this page ...


IULocgo


Named Queries in Reports

 

 

  • No labels