Querying A Table In Reference Data Management (4.0)
- Jenni Wallin
To query a table, you will use the Get Started button from the initial dashboard page or you can click on the Query button on the result view. A Query dialog will open where you will configure the criteria for your query.
Info!
If a query was done previously, last applied query settings will be reloaded. if unable to fully reload, a notification will prompt users to verify and update the values accordingly.
Opening the Query dialog will cause any uncommitted changes to be discarded and the Reference Data Profiles to be refreshed if there are any changes to the Reference Data Profiles.
Options | Description |
|---|---|
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. |
Table | This option appears once you have selected a profile. 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. |
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. Info! Data set is the scope in which query results are displayed and modifications are applied. When switching data set, any uncommitted changes will be discarded. Users switch between data sets with buttons on the footer bar in the query result view. |
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. |
Query Expressions
Options | Description |
|---|---|
Column | This is a column in the selected database table. Note! Only columns with supported data types are available for selection. |
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. |