Physical Data Order

Physical Data Order

This feature allows a user to manually order the rows in a data set.


In order to enable this feature you need to go through the following steps:

  1. Set the OrderMember property of the screen section. OrderMember specifies an entity field which will be used for storing the order value.
  2. The entity field’s data type is an Integer.
  3. It is recommended to set the OrderMember database field as sorted by default (using a Sort Set on the screen’s data structure) because the feature works only if the data is sorted on the order-column.

Do not try to specify a unique index on the ordered database field. This produces an error when you would try to save the data after reordering items.


Setting OrderMember will result in making new UI elements available to the user. These new UI elements are Move Up and Move Down buttons and they are located on the screen section toolbar between the screen section label and add row button.

Clicking the buttons will reorder the lines by changing the underlying data in the order column. It also automatically updates the column when adding, deleting or duplicating a record.