Skip to main content
spyb2323
New Participant
May 29, 2024
Solved

Query database doesn't work

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

sriramk5349
sriramk5349Answer
Inspiring
May 29, 2024

Hi [mention:53e4399458e849be94876965e8b832f2:e9ed411860ed4f2ba0265705b8793d05] ,

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.

View in thread

7 replies

shubhama926776
shubhama926776
Brainy
May 29, 2024

Hello [mention:53e4399458e849be94876965e8b832f2:e9ed411860ed4f2ba0265705b8793d05] 

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.

शुभम्
stefanhelzle0001
stefanhelzle0001
Brainy
May 29, 2024
it doesn't work

This is not a very helpful error description. Can you help us with more details?

spyb2323Author
New Participant
May 29, 2024

[mention:a11f77a729fb4db2af76b09948583328:e9ed411860ed4f2ba0265705b8793d05] 

It is stuck on the Query database node and there is no error.


sriramk5349
sriramk5349Answer
Inspiring
May 29, 2024

Hi [mention:53e4399458e849be94876965e8b832f2:e9ed411860ed4f2ba0265705b8793d05] ,

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.

    Terms & ConditionsAccessibility statement