What is the problem or goal the end user is trying to solve or accomplish?
The sort by feature does not work on the Interactive Table if the row limit is exceeded.
For example: If the row limit exceeds 1000 and you try to apply the sort. First, the table will limit the rows to 1000 then applies the sort by on the columns. This is leading our users to think data is missing when sorting the table.
How are they solving it currently?
We will expand the row limit from 1000 to 5000 to confirm all data is accounted for in the table.
What is the recommended solution by the Customer?
When sort by is applied to a table the query should update to sort by that fields before applying the limit to the rows.