To query a table, you will use can do the following:
click the Get Started button from the initial dashboard page
...
click
...
the Query button on the result view. A Query dialog will open where you will configure the criteria for your query.
| Info |
|---|
Info!If a query was done previously, last applied query settings will be reloaded. if If it is unable to fully reload, a notification will prompt users to verify and update the values accordingly. Opening the Query dialog will cause discard any uncommitted changes to be discarded and refresh the Reference Data Profiles to be refreshed if there are any changes to the Reference Data Profilesprofiles. |
...
Options | Description |
|---|---|
Saved filters |
Allows you to manage saved filters within the Query dialog.
| |
Action | Contains the following actions to manage the saved filters:
|
Reference Data Profile | Allows you to select a Reference Data Profile that contains the table you want to query from. For more on Reference Data profiles, you can refer to Reference Data Profile. |
Search Type | There are two types of search that you can select as follows:
|
| |
Table | This option appears once you have selected a profile and Standard Search Type. This is a dropdown list of tables configured in the selected Reference Data profile. You select from one table in the list to perform your query on. |
Main Table | This option appears once you have selected a profile and Join Table Search Type. This is a dropdown list of tables configured in the selected Reference Data profile. You select from one table(t1) in the list to perform your query on. |
Join Conditions | This option appears once you have selected a profile and Join Table Search Type. Add join conditions to combine two or more tables by selecting Table Name(t2), Join Type and configure Join Constraints. |
The following join types are supported:
Join Constraint is used to specify the conditions for joining tables, for e.g: t1.column_id=t2.column_id. | |||
Show Columns | This option appears once you have selected a profile and a table. This displays all the column names available in the selected table. You can remove and add the columns at your choosing to be displayed in the query result. Clicking on the All button will select all the columns in the table. All columns are selected by default. | ||
Data Set Size | This option appears once you have selected a profile and a table. The value in this field controls the maximum row count per data set. The queried data is fetched from the Platform in data sets of configurable size. A large size typically results in a faster query but it may take longer to display the first data set.
| ||
Query Expressions | This option appears once you have selected a profile and a table. Query Expressions allow you to filter the query results according to the criteria you configure in this option. Click on New Expression to add one to the query. | ||
Sort Expression | This option appears once you have selected a profile and a table, defaulted to first column in ascending direction. Sort Expressions allow you to sort the query results according to the criteria you configure in this option. Click on New Sort Expression to add additional expression. |
Query Expressions
...
Options | Description | ||
|---|---|---|---|
Column | This is a column in the selected database table.
| ||
Operator | This is a comparison operator that is applied to the values in the specified column and the value. The available operators are:
| ||
Value | This field contains a value that is used in the expression. When between is the selected operator, two value fields are displayed. You can use SQL wildcards such % and _ with the operators like and not like. An underscore (_) in the pattern matches exactly one character (as opposed to one byte in a multibyte character set) in the value. A percent sign (%) in the pattern can match zero or more characters (as opposed to bytes in a multibyte character set) in the value. The pattern '%' cannot match a null. |
Sort Expressions
...
Options | Description | ||
|---|---|---|---|
Column | This is a column in the selected database table which data needs to be sorted
| ||
Direction | Ascending - Query result arranged from lowest to highest value Descending - Query result arranged from highest to lowest value |
...
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.  
Choose Select the columns you will want 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.
 |