Query Expression Operators
- Last UpdatedFeb 24, 2021
- 1 minute read
You can use the following operators in a query filter expression.
|
Operator |
Sample |
|
Equal |
"Filter":"FQN eq 'Weather.Los Angeles.Temperature'" |
|
Not equal |
"Filter":"FQN ne 'Weather.Los Angeles.Temperature' |
|
Starts with |
"Filter":"startswith(FQN, 'Weather')" |
|
Ends with |
"Filter":"endswith(FQN, 'Temperature')" |
|
Contains |
"Filter":"contains(FQN,'Temperature')" |
|
Or |
"Filter":"FQN eq 'Weather.Los Angeles.Temperature' or FQN eq 'Weather.Chicago.Temperature'" |
|
And |
"Filter":"FQN eq 'Weather.Los Angeles.Temperature' and Location eq '/Los Angeles'" |
Note:
- If you apply the filter on a String column, ensure that you enclose the String value
in Single quotes, as mentioned in the examples above. However, if you apply the filter
on a non-string column (such as decimal or integer), you can enter the values as-is,
without using Single quotes. For example, "Filter": "OpcQuality eq 192"
- AVEVA Insight does not support compound expressions with more than 3 conditions.
An example of a compound filter expression is:
"Filter":"(FQN eq 'Weather.Los Angeles.Temperature' and Location eq '/Los Angeles')
OR (FQN eq 'Weather.Los Angeles.Temperature' and Location eq '/houston') OR (FQN eq
'Weather.Los Angeles.Temperature' and Location eq '/San Francisco')"