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

0 venkateshamu
A Score Level 2
over 8 years ago

@thanosm AFAIK there is no such functionality which you looking for. But work around is you can create a view in database side based on your requirement and fetch the data from that view using query rule or query entity. Let me know is it works for you.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
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
0 thanosm over 8 years ago

@venkateshamu @venusaikumarc Thank you both for your input. I believe that the SQL View is a more efficient approach, one we've been following generally. We just happen to come across a use case were such a filter is needed because building a new CDT backed on an SQL View just for supporting such a filter seems redundant.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel