Server-side Pagination: Sorting: Cluster Dash: Newly created resource populates at bottom of list; sort order preference ignored

[yonasberhe23]

Setup

• Rancher version: v2.9-head
• Rancher UI Extensions:
• Browser type & version:

Describe the bug
Newly created resource populates at the bottom of the resource list (config maps, secrets) when server-side pag is enabled; sorting preference is ignored.

To Reproduce

1. go to Global settings > feature flags > enable ui-sql-cache
2. go to Global settings > performance > enable `Server-sdie Pagination'
3. go to cluster dash
4. click ConfigMaps in side nav
5. notice secrets list is sorted by name by default
6. create config map
7. notice newly created secret is not sorted correctly

Result
sort order is preference is ignored.

Expected Result
sort order is not ignored.

Screenshots
https://github.com/user-attachments/assets/c6df7482-1225-43bc-889e-7bb239633ed5

Additional context

[richard-cox]

Changes to the collection should result in a re-pagination request, though this area is in flux (handling updates to existing lists)

[richard-cox]

/backport v2.9.next1