Skip to main content
S
spyb2323
May 29, 2024
Solved

Query database doesn't work

  • May 29, 2024
  • 7 replies
  • 0 views

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

Best answer by sriramk5349

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.

7 replies

shubhama926776
shubhama926776
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
May 29, 2024
it doesn't work

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

S
spyb2323Author
May 29, 2024

[mention:a11f77a729fb4db2af76b09948583328:e9ed411860ed4f2ba0265705b8793d05] 

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


sriramk5349
sriramk5349Answer
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