Staged editing allows you to require that changes to data are approved before the changed data becomes permanent. Before the data changes are approved, all users can see the new data, but the rows are highlighted in purple to show that some changes are pending (see Step 12 below). Staged editing is enabled on a table-by-table basis.

Once a table is activated for staged editing, the system creates a copy of the source table. Then, all changes made to data in the source table are stored in the copy until approved. When the edits are approved, the changes from the copy are merged to the source table and then the record in the copy is deleted.

The setup of Staged Editing allows via a Groovy Script to configure which users or roles are able to access the menu item to accept or reject edits performed on staged editing enabled windows.

Note: Do not disable Staged Editing after it has been enabled. This can cause the loss of any changes that have not yet been approved.

Enable Staged Editing

To enable staged editing for a table, follow the steps below:

  1. In the Tables window, open the record for the table.
  2. Select the check box for Supports Staged Editing. In this example, we are using the Section Inventory table.

  3. Right-click on the record for the table and select Apply Changes.
    The system will open the Confirm dialog box which will display the DDL script to be run to create the new Staged Editing table.

  4. Select OK to create the new Staged Editing table.
  5. Open the window that displays data from the table for which you enabled Staged Editing.
  6. Activate Design Mode.
  7. Right-click the window and select Change Control Properties. The system displays the User Control Properties dialog box.
  8. In the left pane of the User Control Properties dialog box, select the top node of the hierarchy. The system displays the Window Properties tab in the right pane. For more information, see Window Property.
  9. In the Window Properties tab, click the check box in the Supports Staged Editing field. The system places a check mark in the check box to denote that it is selected.
  10. Close the User Control Properties dialog box by clicking the OK button.
  11. Exit Design Mode by selecting the Settings menu to display the Design Mode switch and then click the switch to off. Staged editing is now enabled for the table and its corresponding window. 
  12. Now, when a record is edited in this table, the edits will be displayed with a purple highlight showing the changes are not yet approved.
  13. Right-click on the highlighted row and select Show Changes. The system will open a Changes dialog box that shows the original data (top pane) and current data (bottom pane).