User Manual

GETTING STARTED


OTHER EDITIONS


LAUNCHERS


MODULES


PLATFORM


APPENDIX


TUTORIALS & HELPFUL TRICKS


STRATEGIC PARTNER LINKS

Sepasoft - MES Modules
Cirrus Link - MQTT Modules

RESOURCES

Inductive University
Ignition Demo Project
Knowledge Base Articles
Forum
IA Support

ALL USER MANUAL VERSIONS

Ignition 8.1. Offline Version (04/2021)
Ignition 8 Online Version
Ignition 7.9 Online Version
Ignition 7.8 Online Version

Deprecated Pages

SDK Documentation

Employees

Sign In

Skip to end of metadata
Go to start of metadata


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 its parameters.

This data source supports Nested Queries.

Configuring a Named Query Data Source

First select a Named Query by clicking the Selection icon 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 Selection  icon 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