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 ajinkyab277
Certified Lead Developer
over 9 years ago

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
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 ajinkyab277
Certified Lead Developer
over 9 years ago

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
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data