Is there a way I can use like operator in flux or influxql.
Ex:
from(bucket: "Stock/autogen")
|> range(start: dashboardTime)
|> filter(fn: (r) =>
r._measurement == "StockLocations" and
r.LOC like "%NYC%"
)
|>window(every:15m)
|>first()
Or using InfluxQL,
Select * from StockLocations where time >= now() - 15s and LOC like '%NYC%'