...
You can access the dashboard from the Manage View. Go to Manage → Data Management and then select Reference Data Management.
| Note |
|---|
Note! Temporary files are created on the Platform host when the user executes queries via Reference Data Management. These temporary files, stored in |
...
Once you have gotten a query result, the status bar above the toolbar will display query parameters configuration information. The status bar summary will contain selected Reference Data Profile and Table, and if Last Update feature is enabled, the most recent Last Update user and timestampdatetime. Click on the status bar to reveal the list of query expressions applied for the query result.
Subject to user permission settings (that is configured via the Reference Data Profile and Access Controller), appropriate table toolbar buttons will be enabled above the query result view. This bar allows you to select from the operations that you will want to use Reference Data Management for, such as Query, searching for specific data in the columns, Insert Row, Refresh, Export, Import and Delete.
At the bottom of the view, you get the a Previous Data Set and Next Data Set control buttons at the footer bar to switch between Data Sets data sets. The footer also displays data set information and the total of rows for the entire query result. The data set buttons and information are only available if the query result total rows exceeds the Data Set Size. The Data Set control bar also displays the total of rows for the entire query result and Data Set information.
...
(configurable in the Query dialog).
...
Status Bar
Status | Description |
|---|---|
Current Profile | Reference Data Profile selected in the Query dialog. |
Current Table | Table selected in the Query dialog. |
Last Update User | If Last Update feature is enabled for this table in the Reference Data Profile, the name of the most recent user to perform an operation on a record is displayed. |
Last Update Datetime | If Last Update feature is enabled for this table in the Reference Data Profile, the most recent datetime an operation is performed on a record is displayed. |
Query Expressions | Click on the status bar to reveal the list of query expressions configured in Query dialog if any. |
Table Toolbar Options
Options | Description |
|---|---|
Query | Opens the Query dialog, allowing you to tweak with the expressions or query configurations. Refer to Querying A Table In Reference Data Management for more information. |
Search Bar | Filter the current data set to display rows that have any column values that is matching the search barinput. The matched row count is displayed on the right within the search bar. |
Insert Row | Opens the Insert Row dialog for you to add insert more rows of data into your table. Refer to Inserting rows for more information. |
Refresh | Refreshes Triggers a query from the Database with the current query configurations and refreshes the query result view , especially after you have added new rows using the Import functionwith the retrieved updates if any. |
Export | Exports the query result view or the entire table into a file. Refer to Exporting data for more information. |
Import | Imports bulk data from a file into the table. Refer to Importing data for more information. |
Delete | Marks all rows in the query result data set for deletion. Refer to Removing rows for more information. |
Footer Bar
Options | Description |
|---|---|
Previous Data Set | Switches to the previous data set of the query result. |
Next Data Set | Switches to the next data set of the query result. |
Data Set Information | Shows the current data set number, the data set count and the value of Data Set Size configured in Query dialog. |
Total Row Count | Shows the number of rows that are in the query result. |
| Note |
|---|
Note! When switching between data sets, any uncommitted changes will be discarded. |