Hi all,We are using export to excel default functionality for exporting data from record. We are using priority column as initial sorting field. While exporting to excel, for some users its getting sorted with priority and for some users, its getting sorted with id. What could be the reason for this behaviour? The only difference is for user whose excel is having id as sorting, they can see all cases, while for others, they can see only particular cases due to record level security.TIA
Discussion posts and replies are publicly visible
AFAIK Record security is causing the sorting issue. Users with full access see everything sorted by Priority as expected. But for users with limited access, they might only see a partial dataset, which Excel then sorts by the first visible column (like ID) due to pre-sorting or seeing only a subset of data.
Is there any way to fix this issue?Users with full access are able to sort using id and for other users, priority is getting used.
The difference depends on how much data is exported. The export runs in batches of 1000, so if there are less than 1000 rows given current filtering, then the sorting is preserved. If there are more than 1000 rows, then the data is sorted by the PK to preserve consistency of the data. This is default behavior and not currently configurable.
Thanks Peter Lewis Any update on when it will be resolved?And it makes sense because when we were exporting less than 1000, it was working with current filtering and for more than 1000, it takes primary key
This is currently working as intended, as it ensures consistency of the data on export. That being said, enhancing this is on our radar, but I don't have a timeline for when we might change this behavior.
Thanks Peter