Dear Community,
assume you have a table UI items which shows 5 items from the database. Each item has an ordering ID. The ordering ID is important as it defines in which order an backend application needs to process regex expressions in an waterfall approach. Now I like to give the user the ability to move an item up and down in the order to change the which regex expression should be processed first.
How can I reorder all the items in the database when I change the position of an regex from position 4 to position 2? I am not sure how I can do this.
Thank you in advance.