You’re offline. This is a read only version of the page.
Hi.
Let's have a quite big set of data in dataverse, 30 000 records with 30 custom columns.
I want filter this set with 10 criterias.
Each of the is a multiselect (up 20 choices) or range of date.
IE
Filter(Table;
Column1 in col1
Column2 in col2
................
Column10 =< Date1
Column10 > Date2
How the system do it? Is it starting from 1st critermin, filterng then consider 2nd and so on...
What are the general ideas to optimize filtering?
Try to index all the collumn involved in the filtering (you have the maximum limit at 20 columns) this will be optimize the perfomace, but more than that you can archieve using an estructured database as a Dataverse.
Hey @knyklu ,
If you follow the delegation rules for each type of column, you have no problem to go foward your filter,
recomend you to take a look in the documentation , so you can understand better about delegation and query limits.
-------------------------------------------------------------------
If my reply helped you, please give a đź‘Ť
If it solved your issue, please give a đź‘Ť & accept it as the Solution to help other community members find it.
#1
WarrenBelz
48
Most Valuable Professional
#2
mmbr1606
41
Super User 2025 Season 1
#3
MS.Ragavendar
36
Share
Report
All responses (
Answers (
