Can we do 'like' operations in influxdb using flux

Fluxlang
,
2

There are no like operators, but we can use Regex to do the same.

Using InfluxQL:
Select * from StockLocations where time >= now() - 15s and Path =~ /NYC/

Using Flux:

           |> range(start: dashboardTime)
           |> filter(fn: (r) => 
           	r._measurement == "StockLocations" and
                 r.LOC =~/NYC/
           )
          |>window(every:15m)
          |>first()
1 Like