153186 - no subject - Hi Team,\n\nWe have a requirement where

madhankumarb over 9 years ago

Hi Team,

We have a requirement where we to fetch data from report using IN operator in filter. Currently execute process report smart service doesn't allow IN operator in filter. What is option to get data from report using IN. Do we have any plugins for that?

Regards,
Madhankumar. B

Discussion posts and replies are publicly visible

Parents

0 elizabeth.epstein over 9 years ago

2 ideas:
1) Run the service multiple times, 1 for each item in your IN array. Then merge the results.
2) Instead of querying an actual Appian report, re-construct the query using queryrecord() on your original data set: forum.appian.com/.../Scripting_Functions.html
That will allow you to use IN as a filter operator.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 elizabeth.epstein over 9 years ago

2 ideas:
1) Run the service multiple times, 1 for each item in your IN array. Then merge the results.
2) Instead of querying an actual Appian report, re-construct the query using queryrecord() on your original data set: forum.appian.com/.../Scripting_Functions.html
That will allow you to use IN as a filter operator.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data