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
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