Why my filter code occur delegation warning on OR(||) and in
But I searched the delegation ok for SharePoint list. How to fix it?
1) In is not a delegable operator in SharePoint. It will work in some data sources, but not in SharePoint.
2) '||' or is not delegable when one of the clauses isn't delegable. See #1
The best alternative here is to break the filter down into two nested filters. The inner filter should include all the delegable functions and the outer the non-delegable. You'll still get a delegation warning, but if the inner filter gets the list down below the data row limit the function will work.
Which data source is delegatable?
I just in building new app state with some sample data, so I thing I can change the data source type from SharePoint list to a delegable data source.
I found that the table of the delegation of each delegable data source, it seem no one is perfectly match.
So any idea of nested filter for me to make a multi filtering.
The fields need to filter in SharePoint is:
Priority Choice [Low, Normal, High]
Status Choice [New, In process, Completed]
ID Number [1 - infinity)
Date from to
SharePoint is a delegable data source. But there are limits on which functions are or are not delegable. Which functions you can use is different for each data source. Premium data sources like SQL and CDS provide more delegation, but they also require a premium license.
A lot of that depends on your data, and how big its going to get. Also, what exactly is the logic you are using?