# GridRowOrderDragDropParam

### RowOrder Drag & Drop Parameter

If an app config is used as a sub data source, the values will be filled in automatically. If u want to set the parameter manually, the values must match the needed information for a SQL-Update statement. See the example below. In addition the relevant table/tables must be prepared to be capable to read and write the ordering data. See the list provided for Manual ordering of rows in a grid

```
{
   "targetTable": "exampleTableName",
   "targetKeyField":"exampleId",
   "targetRowOrderField":"exampleRowOrder"
}
```

```
-- e.g: Those parameters will lead to an update statement like this
UPDATE exampleTableName SET exampleRowOrder = @newRowOrderPosition WHERE exampleId = @id;
```

{% embed url="<https://youtu.be/i5rwxNfoKJM>" %}