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 narasimhaadityac
A Score Level 2
over 8 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

Reply

0 narasimhaadityac
A Score Level 2
over 8 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

Children

No Data