Querying for Variables¶
The data dictionary (i.e. the variables) can be searched for. Each variable proerties, Categories and Attributes are indexed in Opal’s search engine. Each time a table is updated, its data dictionary is automatically re-indexed, ensuring an up-to-date variable search service.
Note that variables of a table are always indexed (with a latency of 1 minute), whereas the indexing of the table values can be scheduled.
How to Search¶
When navigating in the data dictionary (datasources, tables, variables), the search box is pre-filled with the current context (datasource or table currently visited). Start typing a word that is looked for and the 10 first most relevant variables will be suggested. Selecting one of them will display it.
By default the fields that are searched for are:
labelattribute (any language)
descriptionattribute (any language)
maelstromattributes (any language)
Other fields can be searched for by explicitly defining a term using the pattern
<value>. The search terms can be combined using logical operators
OR (uppercase is required for the operator). The default logical operator is
AND. Wildcard character
* can be used on the values.
The search fields corresponding to the variable properties are:
The search fields corresponding to the variable Attributes are defined by the pattern:
locale are not always defined).
Categories atttributes follow the same pattern, prefixed by
The nature of the variables can be: CATEGORICAL, CONTINUOUS, TEMPORAL or UNDETERMINED.
Search for variables having words starting with “smok” (for instance “smoke”, “smoked”, “smoking” (case insensitive)) in their name or label or description:
You can provide a more accurate query by specifying the field name that is searched:
Criteria can be combined:
Default operator is AND, but OR and NOT operators with parenthesis can also be specified:
RES_F AND NOT (FEV OR FEF)
Search for variables of numerical value type (
valueType:integer OR valueType:decimal
Search for variables with repeatable values in kilograms:
Search for variables having category with name starting with
Search for a chunk of phrase in English
Search for variables having a category with some words in their English