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

Hi Nick

You cannot use * in SQl statement box, But if you want to multiplication in with SQL data You can choose below options

1. Use query entity or Query rule to get the data from table and handle multiplication in Appian
2. If you want to use 'Query Database' node then first get the column value from table and then do multiplication logic in appian (to be specific use apply function in data output tab of Query database node)
Note: - Not recommended if number of rows returned is large
3. You can also use view or store procedure, but then you have to maintain 2 extra data base object and CDT and they have their own drawbacks


Thanks
Ajinkya

Hi Nick

You cannot use * in SQl statement box, But if you want to multiplication in with SQL data You can choose below options

1. Use query entity or Query rule to get the data from table and handle multiplication in Appian
2. If you want to use 'Query Database' node then first get the column value from table and then do multiplication logic in appian (to be specific use apply function in data output tab of Query database node)
Note: - Not recommended if number of rows returned is large
3. You can also use view or store procedure, but then you have to maintain 2 extra data base object and CDT and they have their own drawbacks


Thanks
Ajinkya