145450 - no subject - Hi guys,\nI’m trying to filter a process

lins over 9 years ago

Hi guys,
I’m trying to filter a process variable through SQL Query but it passed an activity parameter with no returns. In process model below, the user would select one project name (in the process start form) and the system should return all the data related to that project. However, right now the system returns all the data in SQL including all the projects we have.

Does anyone know how to filter out other projects and only leave the data regarding the project user selected?

Waiting on line. Thanks a million in advance!

Discussion posts and replies are publicly visible

0 David Williams over 9 years ago

Try adding this logging to get you started and you can see what is actually being run by the query ...

forum.appian.com/.../Logging
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Robert Shankin
Appian Employee
over 9 years ago

Hi Lin,
You might want to consider adjusting your implementation to employ a query rule or an queryEntity expression rule executed via script task rather than the query db node. This would typically be the preferred approach.
Your rule can be configured to take project name as a parameter. This rule can then be easily tested independent of your process. This will require that the target table be in a database that's configured as an Appian data source.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 subhankarb over 9 years ago

Can you please share your SQL query if possible ? The filter input may not be properly defined.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel