Filter data based on startdate

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

OriginalPostID-150592

  Discussion posts and replies are publicly visible

Parents
  • Updated code is givem below:

    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},if(ri!starttime = "Last 7 days",{field: 10 , operator: "LESS_THAN", value: 8},if(ri!starttime = "Last 1 Month",{field: 10 , operator: "LESS_THAN", value: 31},if(ri!starttime = "Last 2 Months",{field: 10 , operator: "LESS_THAN", value: 61},if(ri!starttime = "Last 3 Months",{field: 10 , operator: "LESS_THAN", value: 92},{field: 10 , operator: "LESS_THAN", value:5000})))))
    ),
    With this code filter works if I apply in interface while working but when I save this and try to apply filters from tempo mode it dosnt work . has any one faced this issue?
Reply
  • Updated code is givem below:

    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},if(ri!starttime = "Last 7 days",{field: 10 , operator: "LESS_THAN", value: 8},if(ri!starttime = "Last 1 Month",{field: 10 , operator: "LESS_THAN", value: 31},if(ri!starttime = "Last 2 Months",{field: 10 , operator: "LESS_THAN", value: 61},if(ri!starttime = "Last 3 Months",{field: 10 , operator: "LESS_THAN", value: 92},{field: 10 , operator: "LESS_THAN", value:5000})))))
    ),
    With this code filter works if I apply in interface while working but when I save this and try to apply filters from tempo mode it dosnt work . has any one faced this issue?
Children
No Data