[2.0] sort function doesn't work when re-assignment to _time

[chaclus]

Running InfluxDB 2.0

This is my code of save data to influxDB

Running flux query from(bucket: "test-idm-bucket") |> range(start: v.timeRangeStart, stop: v.timeRangeStop) |> filter(fn: (r) => r["equipmentNo"] == "3fb38f9c-be57-43bd-bf1b-ede34df20d22") |> filter(fn: (r) => r["_field"] == "ljll") |> sort(columns: ["_time"], desc: true) Return result

I find it that sort function doesn't work. Is it caused by my re-assignment to _time?

[HeroAmer]

@vainly You have to add an empty group ( |> group() ) before sorting, here is an example: from(bucket: "YOUR_BUCKET") |> range(start: v.timeRangeStart, stop: v.timeRangeStop) |> filter(fn: (r) => r["_measurement"] == "YOUR_MESUREMENT") |> group() |> limit(n: 10, offset: 0) |> sort(columns:["_time"], desc: true)