Please help me change this influxql query to flux

InfluxDB 2
, ,
1

can someone help me change this influxql query to flux?
SELECT “logfile” FROM “poc” WHERE “stamp” =1669800086000
here stamp is a field not tag.
poc is the measurement.

2

Hello @Rukaiya_Fahmida Welcome to the forum.

This is a bit difficult without know your all your DB details, but try something like this…

from(bucket: "bucket_name")
|> range(start: v.timeRangeStart, stop: v.timeRangeStop)
|> filter(fn: (r) => r["_measurement"] == "poc")
|> filter(fn: (r) => r["tag_name"] == "logfile")
|> filter(fn: (r) => r._value == 1669800086000)
|> aggregateWindow(every: v.windowPeriod, fn: mean, createEmpty: false)
|> yield(name: "your_result_name")