The filter is not working

Leela Venkata Vundavalli

A Score Level 2

over 9 years ago

I am trying to filter the data fetched from getPortalReportDatasubset, but the filter is not working:

load(
local!pagingInfo: a!pagingInfo(startIndex: 1, batchSize: 5),
local!issueIdFilter: ri!currentIssueId,
with(
local!datasubset: getPortalReportDatasubset(
reportId: cons!MYTASKS_REPORT,
pagingInfo: local!pagingInfo,
contextIds: {},
filters: {
{field:"0", operator:"EQUAL", value:local!issueIdFilter}
}
),....

Can anybody please help me?...

Discussion posts and replies are publicly visible

Parents

0 Sathya Srinivasan
Appian Employee
over 9 years ago

What is the value of local!issuedIdFilter? Is it single or array
What is field 0? Number, text, User??
Have you tried using the same filter directly in the report to make sure it works?
Lastly, you are using EQUAL filter which means that it will compare the exact data. Make sure its not partial value. For e.g. if the column value is "Happy", you wont get a result if you try for "Hap" or "*Hap*"
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 Sathya Srinivasan
Appian Employee
over 9 years ago

What is the value of local!issuedIdFilter? Is it single or array
What is field 0? Number, text, User??
Have you tried using the same filter directly in the report to make sure it works?
Lastly, you are using EQUAL filter which means that it will compare the exact data. Make sure its not partial value. For e.g. if the column value is "Happy", you wont get a result if you try for "Hap" or "*Hap*"
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data