Keep sorted data in original order when updating data

[schatzcleat]

Really enjoying working with this package. I am trying to find a way to keep the rows in the same order after using updateReactable, even when the input data has changed the sort order.

The use case for this is when editing data directly in the table/making a determination of it, when the row gets updated it moves spots and can be difficult to track down.

Any thoughts on if there's a current way to implement this? Looks like in React there may be a way with the autoResetSortBy: false argument in useTable , but unsure if there is a way to access that from R/Shiny.

https://stackoverflow.com/questions/66656018/prevent-re-sort-on-data-change-or-while-row-is-being-edited

Thanks for the advice.

[glin]

Hey @schatzcleat, sorted state should be persisted when calling updateReactable(). There are some pieces of state that persist, but others that do not persist due to technical limitations and weird behavior - check out the description for updateReactable():

data should have the same columns as the original table data. When updating data, the selected rows, expanded rows, and current page will reset unless explicitly specified. All other state will persist, including sorting, filtering, and grouping state.

Is it possible that it's the current page being reset back to the first page that's the issue here? If so, you can explicitly specify something like page = getReactableState("table", "page"), or see similar examples at https://glin.github.io/reactable/reference/getReactableState.html

If it's not this, do you have a minimal example to show the issue?

[schatzcleat]

It is actual the opposite effect that I want. By default the sort state persists, but I want the sort order to get reset so that the order I provide my updated in is the one it displays as. That way when the sorted value changes it does not move the row of interest to a new place.

I will try to put together a small reprex later today.