SQL Query Property Binding Missing in Perspective

Ignition
1

Hi all,

Is there currently no way to configure a SQL Query property binding aside from a named query or a runScript expression in 8.0 Perspective? I believe we were able to write the Query within the binding manually if needed.

Or am I missing a better solution here? The use case is to containerize this query in a template/view that I can share around. It works fine for tags/named queries/runScripts, but I would like to avoid these if I can.

Cheers,
Roger

2

Direct SQL queries are deliberately absent from Perspective - they’re 1. a big security problem and 2. harder to optimize.
If you can’t achieve what you want with named queries, then DB access through scripting is the recommended approach.

3

Ahhh, makes sense! Thanks for the info. I think we’ll use the named query approach for this particular view, I’ve used it everywhere else but this window.

Best,
Roger