Quoting rules
When querying the InfluxDB® directly and not using WinCC OA query functions (dbQuery, dpGetPeriod), the following rules apply.
For | Use | Example |
SELECT | double-qoutes |
SELECT "_visible"
|
FROM | no qoutes |
FROM Events.Event
|
WHERE column name | double-qoutes |
WHERE "_state"
|
WHERE string or tag value | single-qoutes |
WHERE ... = 'text'
|
WHERE numeric value | no qoutes |
WHERE ... > 15
|
Regular Expressions | forward-slash |
WHERE ... =~ /^[0-9]?/
|