Table - keep selected row after update

Queries and Resources
1

Hi,

If I edit/update the selected record, the table refreshes and the selected row will remain on the same spot, not the table (5th row instead of the record with id 123). I founded working version here: https://retool.com/templates/postgresql-admin-panel, but I can't get it working in my app. I used transformer, turned it off, but it didn't help either. Could there be problem I use UUID for indexing the rows? Or am I missing some setting which enables to stick to the selected data?

Thanks in advance!
Jakub

2

Hi @jakub!

My guess is that the edit you're making changes how the data is ordered when it's returned from your db. In the template you sent the data seems to be ordered by id which is immutable.

I'm not sure though! Would you mind sharing how you have your update query set up and giving an example of a change that causes the behavior you're describing?