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.