The Reference Data Management Dashboard will allow you to do the following:
...
Rw ui steps macro | |||||
---|---|---|---|---|---|
On the Query dialog, choose a Reference Data Profile by clicking on the Browse button. Look for and select the profile that has the tables you want to search from using the Select Reference Data Profile dialog.
Select a table from the Table dropdown list. The tables configured in the Reference Data Management profile will appear here.
Choose the columns you will want to view in the query results and configure the maximum data set value should you require it to be set to a different number.
You can also add query expressions to refine the result of the query by filtering out certain data. If you did not configure any expressions, the entire table (up to the number set in the data set value) will be displayed.
Click on Apply and the result will be shown in a view. From this view, you can then query again, insert a new row, edit the fields in the view, delete rows, refresh the view, export the data set, export the entire table or import from data from a CSV file. |
Inserting new data into the table
Reference Data Management
Editing an existing field in the table
...
Item | Description |
---|---|
Refresh State Interval | Use this field to set the status line refresh interval in seconds. |
Refresh State | Click on this button to refresh the status line. |
Stop | Click on this button to stop the active process. |
Edit Tab
In the Edit tab you can:
Edit, delete, and insert rows
Filter table data
Select columns to display
Change sorting order
...
Web UI - Edit tab
Item | Description |
---|---|
Select All | This button selects all the displayed rows. |
Clear All | This button clears the selection of all rows. |
Toggle Filtering | This button opens a text box above each column label. You can use this text box for filtering rows. |
Show Only Modified/Show All | This button toggles filtering of unedited rows. |
Export/Import | This button opens the Export/Import tab. |
Columns | This button opens a dialog where you can select columns to display. |
Pagination Control | The pagination control is displayed if there is more than one page for the data set. You can use this control to navigate between pages. |
Previous Data Set | This button is displayed if there any previous data sets. |
Next Data Set | This button is displayed if there any consecutive data sets. |
Insert | This button opens a dialog where you can insert rows. |
Update | This button opens a dialog where you can edit selected rows. |
Delete | This button opens a dialog where you can delete selected rows. |
Cancel Selected | This button cancels changes on the selected rows. |
Cancel All | This button cancels all changes. |
Review | This button opens a page where you can display all your edits and commit the changes to the database. |
To insert a row:
Click the Insert button. The Data Editor dialog opens.
Fill out the form in the dialog and click Apply Changes and Exit.
Click Review. All the pending changes are displayed.
Click commit.
To update rows:
Alternative A:
Click on the cells in the grid that you want to edit and update the value.
Alternative B:
Select one or more rows by either clicking on the check boxes on the leftmost side of the table or the Select All button.
Click the Update button. The Data Editor dialog opens.
Edit the field values.
Use the paginator control to navigate between the selected rows.
Click Apply Changes And Exit.
Click Review. All the pending changes are displayed.
Click Commit.
To delete a row:
Select one or more rows by either clicking on the check boxes on the leftmost side of the table or the Select All button.
Click the Delete button. The Data Editor dialog opens.
Use the paginator control to navigate between the selected rows.
Click Apply Changes And Exit.
Click Review. All the pending changes are displayed.
Click Commit.
Export/Import Tab
In the Export/Import tab you can bulk load data to and from the database.
...