Dynamic named queries in perspective
planned
A
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.
Log In
u
uy huynh
Been 5 years :(
b
betti francesco
Sorry I'm missing something maybe: isn't the system.db.runNamedQuery enough to do this?
B
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.
P
Paul Griffith
planned
P
Paul Griffith
under review
P
Paul Griffith
Merged in a post:
Dynamic named queries in Vision and perspective
T
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)