eclipse-sdv-blueprints / fleet-management

A close to real-life showcase for truck fleet management where trucks run an SDV software stack so that logistics fleet operators can manage apps, data and services for a diverse set of vehicles.
Apache License 2.0
16 stars 10 forks source link

Resolved the FMS-Server vehicleposition influx query syntax #10

Closed devcode100 closed 1 year ago

devcode100 commented 1 year ago

The Request: curl -v -s http://127.0.0.1:8081/rfms/vehicleposition?latestOnly=true | jq returned following error: error retrieving vehicle positions: non-success response: '400 Bad Request', body: '{"code":"invalid","message":"compilation failed: error @6:5-8:75: expected RPAREN, got EOF"}' Below Influx DB query was executed:

 from(bucket: "demo")
 |> range(start: 0, stop: 1693563160)
 |> filter(fn: (r) => r._measurement == "snapshot")
 |> filter(fn: (r) => r["vin"] =~ /.*/)
 |> filter(fn: (r) => r["trigger"] =~ /.*/)
 |> filter(fn: (r) => contains(set: ["createdDateTime","latitude","longitude","altitude","heading","speed","positionDateTime","tachographSpeed", "wheelBasedSpeed"], value: r._field)
 |> last()
 |> pivot(rowKey: ["_time"], columnKey: ["_field"], valueColumn: "_value")
sophokles73 commented 1 year ago

@devcode100 can you please rebase your PR to current main branch?

eriksven commented 1 year ago

@devcode100 good finding and thank you for the fix.

devcode100 commented 1 year ago

@devcode100 can you please rebase your PR to current main branch?

@sophokles73 Rebased.