Arbitrarily complex boolean expression in WHERE clause

influxdb
#1

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?

#2

Of course in the query that I executed, I used actual RFC3339 timestamps (e.g. '2011-08-30T13:22:53.108Z') in place of t1, t2, t3 and t4 shown in the example.