Manipulating The Data In Reference Data Management
- Kevin Wu
- Yeok Hong Ng
Subject to user permission settings that is configured via the Reference Data Profile and Access Controller, Reference Data Management allows you to manipulate the data within the query result of your table. You can insert one or more new rows, edit one or more fields in the data. You can even remove rows of records from the result.
Any insert, edit or delete action applied to the data set will cause the modification status bar to appear. The modification status bar will display the total uncommitted modification count and a Review button to open the Review Modification(s) dialog.
The Review Modification(s) dialog allows you to review, discard or commit the modifications. On commit, the Reference Data Management will attempt to commit the changes into the database table and refresh the query result with the latest changes.
Info!
Data set is the scope in which modifications are applied. When switching data set, any uncommitted changes will be discarded.
Any uncommitted changes will also be discarded when changing the query configurations or leaving Reference Data Management page.
Â
Note!
Manipulating the data is only applicable if the Standard Search Type is selected in the Query dialog. Refer to Querying A Table In Reference Data Management for more information.
Inserting rows
The following are steps to insert your own row into the table.
Editing the fields
The following are steps to edit row(s) in the table using Reference Data Management. You can only edit one row at a time from the query result view.
Removing rows
The following are steps to remove rows from the table using Reference Data Management.