I am on Appian 7.7 and I am using Portal to SAIL plug-in. I am using 'IN'

tapans over 9 years ago

I am on Appian 7.7 and I am using Portal to SAIL plug-in. I am using 'IN' operator to filter the data but I am not getting result. Could anyone please help me understanding the 'IN' operator functionality by providing specific example?

-----
For reference, I am mentioning the plugin rule I am using :

=getportalreportdatasubset(
reportId : cons!My_report
pagingInfo : a!pagingInfo(startIndex :1,batchSize: -1),
contextIds : {},
filters : {
{
field : 23,
operator : "IN",
value : ri!taskassignee
}
},
)

Here I am not getting desired result using "IN' operator.
-------

Thanks!...

Discussion posts and replies are publicly visible

0 siddharthg521 over 9 years ago

Tapan,
In order to debug this, try removing filters value from the above code and then see if the data is coming on your task report or not.
If yes, then there is something wrong in the filters. One thing in filter that usually gets wrong while implementation is "field".
The field on which you want the filters to apply on, should be at nth column location in your source portal report, where SOMETIMES FIRST COLUMN NUMBER STARTS FROM 0 AND SOMETIMES FROM 1.
So, I would suggest trying both and see which one works.

I too faced the similar issue in past.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 tapans over 9 years ago

Hello Sid,

Thanks for you response!

In my case I am getting the field value by calling the data-subset in portal to sail plugin which is giving that field value. Please see attached screenshot for reference. So I don't think this is same kinda issue mentioned above.

What do you think? Will wait for your further suggestions/guidelines.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 sikhivahans over 9 years ago

@tapans A few points noted by me which might help you:
>> If you created the report by 'Create a new portal report', then create a new report by making 'Save as' of out of the box report.
>> Also IN operator isn't workinbg for few columns. For instance, when I used this functionality for Task report, IN operator worked for tp!name property but it didn't work for tp!display.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 tapans over 9 years ago

Thanks sikhivahans but the report I am pointing to is not the new portal report, it is copied from the existing one using 'Save as'.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 radhaa over 9 years ago

Hi tapan, here field Id needs to be text value, keep quotation on field value.
=getportalreportdatasubset(
reportId : cons!My_report
pagingInfo : a!pagingInfo(startIndex :1,batchSize: -1),
contextIds : {},
filters : {
{
field : "23",
operator : "IN",
value : ri!taskassignee
}
},
)
For reference Please see the attached document
Portal to SAIL Instructions v1.2.pdf
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 tapans over 9 years ago

Unfortunately, it didn't work even after using quotation for field value. Already referred the doc. you have provided before and tried the suggestion. Further ideas/discussion would be much appreciated.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 sikhivahans over 9 years ago

@tapans Yes, it's not about the quote because I worked it out in several ways but unable to retrive the results. One more option is to use your filter criteria in place of already existing columns (which came along with default 'Save as' report). Also as I said, IN operator didn't work for me in all cases.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel