Skip to main content
S
sathyan315869
February 10, 2025
Solved

Process model query database use process variable as filter

  • February 10, 2025
  • 6 replies
  • 0 views

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)

Best answer by stefanhelzle0001

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.

6 replies

stefanhelzle0001
stefanhelzle0001
February 10, 2025

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

S
sathyan315869Author
February 10, 2025

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.

stefanhelzle0001
stefanhelzle0001
February 10, 2025

Well ...

Did you consult the documentation of that smart service?

Terms & ConditionsAccessibility statement