Hi All,
I am trying to quey the view which has 20000 rows. when i apply filter to one of the calculated column which has 0 rows present, queryentity still throws below error.
Expression evaluation error at function a!queryEntity: An error occurred while retrieving the data. Details: Unexpected error executing query (type: [ELMRISKREDUCTIONLANDINGPAGEVWDT16641], query: [queryentity expression], order by: [[Sort[eucInventoryId asc]]], filters:[(currentReductionStage in TypedValue[it=103,v={Process Re-engineering/Non GFT/ITeSS,}])])
We tried optimizing the view as well, but no luck.
Any suggestion would be appreciated.
Discussion posts and replies are publicly visible
The view evaluates calculated columns on all 20,000 rows before applying filters, causing timeout even for 0-row results. Views often cause performance issues. Since you already mentioned that you tried optimizing your code, I recommend using Record Types with Data Sync.