How can I use InfluxDB query language to execute a query that uses AND
expression of multiple OR
expressions? I want to SELECT
the data samples between two different time regions, say from t1 to t2 and from t3 to t4, in a single query. I tried something like this -
SELECT value FROM measurement WHERE ("time" > 't1' AND "time" < 't2') OR ("time" > 't3' AND "time" < 't4')
But it returned me an empty result. What am I missing?