Move Table Rows Up/Down

Ignition
1

Hello,
I am using a power table component which is connected to a database table.
Is there a way to move selected rows up and down using buttons?

Thanks

2

In vision, the power tables have selectedColumn and selectedRow properties you can manipulate with scripts

3

I assume you’re using a query to populate your data, in which case the order of rows is determined by your select query. You can manipulate this dataset in script, but it will revert back to the query order whenever the query is executed again. To fix that, you’ll most likely need to add a new order field to your sql table and update that

1 Like
4

I didn’t even read the question that way, I guess I miss interpreted. I’ve done this before like @nminchin suggested, I used a priority column to allow the re-ordering of the data.