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

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.

Try using queryportalreport function

We have achieve this using getPortalReportDataSubset' function which was available in Portal to sail plug-in, But I am not able to find this plug-in on forum any more.
But still if you want to use this function(which is not recommended as it is not available on forum) you can use the attached plug-in


Example:-
getPortalReportDataSubset(
reportId:cons!REPORT_ID,
pagingInfo: rule!mo_pagingInfo(1,300,null),
contextIds: {},
filters: {
{ field: "0", operator: "IN", value: ri!filterValue1},
{ field: "8", operator: "IN", value: &ri!filterValue2 }
}
)
Please refer below link for more info
getPortalReportDataSubset
forum.appian.com/.../e-150475
forum.appian.com/.../e-148825

Portal to SAIL_1.2.3.zip

You can use a!queryProcessAnalytics() to get the Portal Report data in which you can use "IN" operator as filter.