Named_query not populating

Ignition
, ,
1

I'm building a new report based on an existing report. The report includes a table that is populated by a named_query. The named_query in each report is identical except it uses a different data source. I can run the named_queries by themselves and I get the data I want. But I can't get it to populate in the new report.

Doing a Preview on the "good" report, I get this:

image
image452×612 42.7 KB

Which goes on for several rows.

But when I preview the new report, I get:
image

There's nothing in the xml node for named_query.

What am I missing?

2

Make sure the parameters are what you think they are.
Maybe try a simpler query to check them.

Also, how do you change the data source ?

4 Likes
3

The named query allows us to select the data source. I am reading from two databases but the table schema are identical.

Like I mentioned, I am able to run the queries from the named query test and they work just fine. I reviewed the two parameters and they are both correct syntax and spelling.