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

erickp over 8 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

Parents

0 Stefan Helzle
A Score Level 3
over 8 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

Reply

0 Stefan Helzle
A Score Level 3
over 8 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

Children

No Data