function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
Torsten StaniendaTorsten Stanienda 

How to limit result set with Enhanced Lightning Grid (aka Sortable Data Grid)?

Hi all, we are using Enhanced Lightning Grid component, which is really a fantastic alternative for related lists and for working with custom query results. Unfortuntely our query gives a result set that is bigger than 50,000 rows and the component runs into an ExecutionException. Even if I pre-filter the result set down - as soon as I change the filter in the Lightning component I get the ExecutionException again. I was not able to include the SOQL LIMIT statement neither within the example query nor within the filter criteria. Is there an option to configure the Lightning component in a way to manage query result sets bigger than 50,000 records (or to limit it to that size)?
Venus Hindocha 22Venus Hindocha 22
Did you try the "Advanced Config" option ? i am unable to access the help files for that so dont know the exact syntax, however i assume the Advanced Config lets you do that.