Skip to main content
This is more of a back end engineering question than a functional "how-to" question, but I haven't found an answer on Google.

 

A report's filter criteria is basically just a query, in metadata form. In fact, you can extract report filters as metadata through the API. But whether you look at it through the front end / UI or the metadata / API, it's just a series of predicates.

 

Does Salesforce evaluate these predicates in the order they're entered when the report is built, or does it optimize the order they execute "on the fly" when the report is run, or does it have an order built in that it runs them? Or last option, is it just parkour - there isn't a discernable order it's firing them?

 

I ask because the order in which Salesforce's reporting engine executes these predicates definitely affects runtime depending on how many records you have and what filtering you're using.
3 respuestas
  1. Manoj Nambirajan (Dell Technologies) Forum Ambassador
    20 may 2021, 15:39
    To my understanding it will go in the order you define in the Filter Logic you have defined.. If no filter logic.. then it will take one line after the other.

     

    In case you have slowness in report performance due to growth of data.. have you tried skinny table implementation? Thats one way to improve performance.
0/9000