Hi
I'm trying to use the QUERY DATABASE SMART SERVICE to delete few records from my database tables
My query is as follows : DELETE FROM <TABLE_NAME> WHERE ID = <VALUE>
Now I want the value to be dynamic. I dont know how to pass on dynamic value.
I tried using the process variables, I created node inputs and tried accessing via ac!. But none works
Anyone can please help me in getting dynamic values for the query above ?
Discussion posts and replies are publicly visible
I think you're on the right track. It can be dynamic using the ac!
But you can also use delete from data store entity smart servicedocs.appian.com/.../Delete_from_Data_Store_Entities_Smart_Service.html
Hey,I actually did try this
The only thing different is :
a. naming of the variable, ( ~1. )
b. And I was getting an error saying "Statement Parameter 1 Not Set"
the error :
You need to manually create first the variable in the SQL statement.
ac!varName and it will automatically create the input in the data tab.docs.appian.com/.../Query_Database_Smart_Service.html
If it is creating the variable automatically, how will it map the value then ?
Like suppose I write ac!requestId in the query, How will it know which request ID to take ?
Because request Id is one of the values from a cdt which is coming to the query node
Once the node input is created, you can map the process variable to the value.
Yess,
I am actually new to appian, It was creating the input variables and I kept removing it thinking it is some glitch. But now I mapped the values according to what you said, and it actually did work
Thank you so much for the help.