For the Query Database Smart Service, it looks like it doesn't allow an aste

nickh647 over 8 years ago

For the Query Database Smart Service, it looks like it doesn't allow an asterisk (*) anywhere within the SQL statement field. The problem I'm running into is that I need to do a multiplication function within the SQL.
How do would we do multiplication in that SQL Statement box without using the asterisk?

Discussion posts and replies are publicly visible

Parents

0 Robert Shankin
Appian Employee
over 8 years ago

Glad you found your solution, Nick.
It can be difficult to get comfortable querying databases without SQL using Appian. But, Appian has been designed to enable designers to do exactly that.

It's recommended that you avoid use of the query database smart service, or keep it in mind as a last resort. Appian's query rules and functions are more secure in the Appian context, and configurations that use the query database smart service tend to involve more steps when the time comes to promote applications across environments.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 Robert Shankin
Appian Employee
over 8 years ago

Glad you found your solution, Nick.
It can be difficult to get comfortable querying databases without SQL using Appian. But, Appian has been designed to enable designers to do exactly that.

It's recommended that you avoid use of the query database smart service, or keep it in mind as a last resort. Appian's query rules and functions are more secure in the Appian context, and configurations that use the query database smart service tend to involve more steps when the time comes to promote applications across environments.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data