Saving row order: Move up and save?

Suite and Optimus Suite 5
#1

Hello community,

I would like my grid to save the order of the rows when I rearrange rows, moving rows up or down.
Is there any way to do this?

Cheers.
-Luca Ban

#2

Does anyone have any ideas on how I would be able to accomplish this?

#3

Please, try to set the second attribute of the setUpdateMode to “true”:
dp.setUpdateMode(“cell”, true);
docs.dhtmlx.com/api__dataprocess … emode.html

#4

Dear sematik,
I think I would need to refrain from using an SQL query that says ‘ORDER BY’ but how would it know in which order it needs to show the rows upon reload?