I'm trying to save the filter with Or and 5 criteria. but it only let me save 4.
do you know any workaround or what is the litmit of this
a!queryLogicalExpression( operator: "OR", filters: { a!queryFilter(field: "year1", operator: "<", value: 2021),a!queryFilter(field: "year2", operator: "<", value: 2021),
a!queryFilter(field: "year3", operator: "<", value: 2021),
a!queryFilter(field: "year4", operator: "<", value: 2021),
a!queryFilter(field: "year5", operator: "<", value: 2021)
} )
Discussion posts and replies are publicly visible
When you say "it only lets me save 4" what exactly are you experiencing? AFAIK there's no limit on the queryFilters you can add (at least, not anywhere near the small numbers you're working with)
Hi Stewart Burchell (stewart.burchell), One doubt on this but will we not experience any performance issue if we are dealing with large amount of data.
Its an inescapable truth that you don't get something for nothing, so the more data you're processing the longer it will take. You can address this in different ways: