Wildcards in queries
- Last UpdatedOct 09, 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 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.