...
Options | Description | ||
|---|---|---|---|
Column | This is a column in the selected database table which data needs to be sorted.
| ||
Direction | You can select to view the query results in the following manner:
|
Querying a Result
| 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 Search Type and a table from the Table dropdown list. The tables configured in the Reference Data Profile will appear here. 
Select the columns to include or 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 will be retrieved and up to the number set in Data Set Size will be displayed at a time in the query result view.
Add sort expressions to specify sort criteria for retrieving data in ascending or descending order. 
Click on Apply and the result will be shown in a view. The status bar at the top and the footer bar displays information about the current query configuration. Click on the status bar to reveal the list of configured query expressions if any. From this view, you can then query again, filter with the Search Bar, switch to another data set, 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.
 |