Ignition 7.9.10 report viewer: WARN: Error executing query parameter expression ''''

Ignition
1

I’m not sure if I’m confused or if this is a bug, but I’m trying to set the default value for some report parameters to ‘’, eg, the empty string. That way I can compare it like (Column = :Param or :Param = ‘’) in the SQL, which works perfectly every time. So I’m not clear why I get several of

WARN: Error executing query parameter expression ''''

at the bottom of the report every time I execute, even in the published production version, where I’d expect mere warnings to not be shown at all. Is there another way I should be making empty strings? Or do I have to make a sentinel value of some sort?

2

Are you actually passing the quotes into the parameter? If so, don’t. Just pass an empty string.

3

That’s the weird part, it does this even if I don’t supply any parameters at all. And it clearly is quoting an empty string to fill in the query since it’s valid and runs correctly, but it pops up this annoying message at the bottom of the report every time.