Filter out a single row(record) Based On TimeStamp (_time) column

1

Hi , I want to filter a single record(row) based on timeStamp.

How Can we filter a single record based on timeStamp(_time) coloumn??

from(bucket: “timeSeries1”).
|> range(start: s, stop: stop)
|> filter(fn: (r) => r[“_measurement”] == “user”)
**filter(fn: (r)=> r._time==2023-02-17T11:18:00.205Z)-------------This filter is not working

i want to get record (row) based on _time column

let say i want 2nd row where _time=timeStamp
how can we do it in Flux lang query

image
image1276×472 24.2 KB

2

Hi @Anish_kumar Welcome to the InfluxDB forum.

I was able to filter out a single record based on the _time column using this:

  |> filter(fn: (r) => r._time == 2023-02-25T12:46:43.344Z)