I am fetching date from portal report to SAIL report, but filters are not working in SAIL.Following code I have used.local!transactionSummaryData:getportalreportdatasubset( reportid:cons!IQ_TRANSACTION_SUMMARY_REPORT_ID, paginginfo: topaginginfo(1,-1), contexids: {}, filters: if(ri!starttime = "Last 1 Day",{field: 10 , operator: "LESS_THAN", value: 2},{field: 10 , operator: "LESS_THAN", value:5000}), if(ri!starttime = "Last 7 days",{field: 10 , operator: "LESS_THAN", value: 8},{field: 10 , operator: "LESS_THAN", value:5000}), if(ri!starttime = "Last 1 Month",{field: 10 , operator: "LESS_THAN", value: 31},{field: 10 , operator: "LESS_THAN", value:5000}), if(ri!starttime = "Last 2 Months",{field: 10 , operator: "LESS_THAN", value: 61},{field: 10 , operator: "LESS_THAN", value:5000}), if(ri!starttime = "Last 3 Months",{field: 10 , operator: "LESS_THAN", value: 92},{field: 10 , operator: "LESS_THAN", value:5000}) ...
OriginalPostID-150592
Discussion posts and replies are publicly visible