hi
I would like to ask a question
I want to know how to use Query database, so I tried it, but it doesn't work.
Here is my query database
Discussion posts and replies are publicly visible
Hello 8888 Based on your query, you are expecting an id to be returned. In data-> output tab, you might see a new Appian variable named AC!~1<id>. Store the value of this variable in your desired process variable (pv!). If you have more columns to retrieve more ac! variables gets generated and need to stored in pv! to capture it.
8888 said:it doesn't work
This is not a very helpful error description. Can you help us with more details?
Stefan Helzle
It is stuck on the Query database node and there is no error.
Hi 8888 ,
Query database node is assigned to some person as you can see user icon on it. Please remove assignment in that node or lane assignment or run the node as automatic activity. And check the output variable names also.
8888 The output variable name should be 'AC!~1<id'. While your column name is "id", the table name is being populated. I would recommend deleting the smart service and retrying the same step.
Per the documentation your outputs should look like this:
Sri Ram Kaja
Thank you for your reply
Deleting the smart service and retrying the same step and add query node assignment to automatic activity.It work for me.