I am using process model to create simple application to use accountid column from one table to filter other table. The accountid list is passed as PV but I am not able to pass the PV in SQL query and its not accessible even after creating a input variable.
SELECT Account_id,Name,'Status code','C&D' FROM Account_table where Account_id in (pv!bkk_act_list.Account_id)
Discussion posts and replies are publicly visible
I would try to do that using record queries.
We discussed your problem in another thread: https://community.appian.com/discussions/f/new-to-appian/38487/query-process-variable-of-record-type
in the other problem I was trying to use it in a script where I passed both the table value into the script. I will give you more context. I am using community environment I am not able to use excel plugin or data store entity. I understand that this can be done in queryRecordType. This POC and I want to make use of process variable rather than doing it by record type.
Well ...
Did you consult the documentation of that smart service?
Yeah I checked https://docs.appian.com/suite/help/24.4/Query_Database_Smart_Service.html and couldn't find any implementation of process variable. Hence using the forum. That documentation could use more codes.
Hm ... the documentation includes examples where AC variables are used. Did you consider to use those to get started? On the node data inputs, you then copy the data from PV to AC.
I used input variable directly and did not work. Now I see AC. Sorry about the miss... Thanks for the information. I will check out the Activity Class Parameter.