In the Query Smart service, we have the option to hard code the SQL queries. Is

erickp over 9 years ago

In the Query Smart service, we have the option to hard code the SQL queries. Is there any way to dynamically get the SQL queries? For instance, if I have some SQL queries in a database table, I coudl use a script task to retrieve this SQL query and store it on a process variable. I would want to use this process variable in the SQL field on the Query Smart service. Is this possible? Will it be possible in later releases of Appian?

Discussion posts and replies are publicly visible

0 Carlos Santander
A Score Level 2
over 9 years ago

Erick, as you mention, the query in the Query DB node has to be defined statically. As for dynamic queries, you can check other posts on Forum, such as forum.appian.com/.../e-175285
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 narasimhaadityac
A Score Level 2
over 9 years ago

@erik, it would not be possible through Query Smart Service, if you closely look at this, when you give a select query and click on the output node, it will give you the selected columns values to be stored . if you are going to dynamically generate a query, when you would not be able to cast this to any pv variable. so i believe we may not be able to achieve this. if you want to do this you can try looking for a custom plugin development.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Stefan Helzle
A Score Level 3
over 9 years ago

Depending on what type of dynamic you need, queryentity() can be of help. Create an expression that does the query and put that in a script task to store data in process variables.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel