Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

At the bottom of the view, you get the Previous Data Set and Next Data Set buttons at the footer bar to switch between 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(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 more rows of data into your table. Refer to Inserting rows for more information.

Note

Note! This is only available for Standard Search Type.

Refresh

Triggers a query from the Database with the current query configurations and refreshes the query result view with the retrieved updates if any.

Note

Note! This is only available for Join Table Search Type.

Export

Exports the query result view or the entire table into a file. Refer to Exporting data for more information.

Note

Note! This is only available for Join Table Search Type.

Import

Imports bulk data from a file into the table. Refer to Importing data for more information.

Note

Note! This is only available for Standard Search Type.

Delete

Marks all rows in the data set for deletion. Refer to Removing rows for more information.

Note

Note! This is only available for Standard Search Type.

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.