Query Entity Filter Parameters

thanosm over 8 years ago

Hello,

We would like to know if it is possible to create a Query Entity rule that uses a filter where it checks for equality between two columns of the Query Entity. As far as we know, the filters require a column and value. We would like the value to be another column.

Discussion posts and replies are publicly visible

Parents

0 Venu over 8 years ago

@thanosm, In Addition, you can also do work around in Appian using functions. Get the result in local variable then use appian functions to filter required output.
index()
wherecontains(),
--------or----
apply()
display()
------------------
index(local!cdt,wherecontains(index(local!cdt,"col1",{}),index(local!cdt,"col2",{})),{})
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 Venu over 8 years ago

@thanosm, In Addition, you can also do work around in Appian using functions. Get the result in local variable then use appian functions to filter required output.
index()
wherecontains(),
--------or----
apply()
display()
------------------
index(local!cdt,wherecontains(index(local!cdt,"col1",{}),index(local!cdt,"col2",{})),{})
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data