Dynamic named queries in perspective | Voters

Dynamic named queries in perspective

planned

Ankit Karwa

Perspective right now only supports named queries in query bindings. It would be tremendously useful to allow use of dynamic named queries by binding them to params/expressions. Without this, its impossible to templatize something with named query like a table.

May 1, 2020

uy huynh

Been 5 years :(

betti francesco

Sorry I'm missing something maybe: isn't the system.db.runNamedQuery enough to do this?

Brian Karabinchak

betti francesco: Personally I try to avoid scripting if a binding is capable of doing the same thing. So having an expression that determines what namedquery to run, and having a table data property bind what named query it runs on that expression would be a different way to achieve what your script would.

Paul Griffith

marked this post as

planned

Paul Griffith

marked this post as

under review

Paul Griffith

Merged in a post:

Dynamic named queries in Vision and perspective

Tord van Delft

I would love to select named queries by stringpath binding. There are obvious reasons for this. Atm, I need to swap syntax on my named queries based on SQL type (mariaDB/MSSQL)

January 15, 2021