Wildcards in queries
- Last UpdatedSep 19, 2024
- 1 minute read
In current alarm queries, you can use wildcards only in the Tagname part of the query and not in the Provider, Group, or Node part of the query. A valid example is:
\galaxy!Mixing!RotorBlade*
In query filters that are used for current queries, the same restrictions apply.
In query filters that are used for historical queries, you must convert the operator and wildcard to SQL syntax according to the following table:
|
Current Query |
Historical Query |
|
|---|---|---|
|
Operator |
= |
Like |
|
Wildcard |
* |
% |
For example:
Provider = ‘galaxy’ AND Group = ‘Mixing’
AND Name Like ‘RotorBlade%’
If you want to use a query filter containing a wildcard for a current query and a historical query, create two separate query filters. If a column contains null data, it cannot be retrieved using the Like operator.