I have reviewed all the commands BUT where is the UPDATE or equivalent command to replace wrong values <0 reported by my sensors ??

[Sofianov]

URL for relevant page?

What products and version are you using?

Where did you look before opening the issue?

[sanderson]

@Sofianov Some information for some context: https://docs.influxdata.com/influxdb/v1.8/concepts/crosswalk/#influxdb-is-not-crud

To update a field value, write a new point with the same measurement, tag set, timestamp, and field.

[Sofianov]

Well it is very hard to correct these values.

it reminds me when I was working on equity and futures markets... with bad prices...

Well I guess that without a serious admin GUI I have to consider MySQL just because you can correct a value. I said a value and existing value.

Serious limitation here.

Thanks for any help

[sanderson]

You can update them by overwriting them. You need to query the points you want to updated, convert the points into line protocol, update the values so they are correct, then insert them back into the database.

[Sofianov]

Thanks Sanderson

I have tried this quick method : I can of course view my bad values here

select from GardenT where value<0 but this is NOT working for some reason! select from GardenT where ("value<0" *-1) - 100

any idea by chance?

Thanks

[sanderson]

@Sofianov Are you using Grafana or Chronograf?

[Sofianov]

Hi Scot

Grafana

On Tue 12 May 2020 at 01:56, Scott Anderson notifications@github.com wrote:

@Sofianov https://github.com/Sofianov Are you using Grafana or Chronograf?

— You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub https://github.com/influxdata/docs.influxdata.com/issues/2822#issuecomment-626986908, or unsubscribe https://github.com/notifications/unsubscribe-auth/AIXEAOIQY7HUHRTF3TYPZJLRRBYBHANCNFSM4M4EMQ4Q .

[sanderson]

I don't know Grafana very well, but I know Chronograf has a feature that lets you view raw data. I'm curios to see what the actual values are in the erred data points.

[Sofianov]

Well instead of reading 36 the sensor went on error and trow me -136 .... thats whay I have tried to select the <0 and +100 and * -1 simple but for some reason didn't work on InfluxDB

Sofian

On Tue, May 12, 2020 at 6:39 PM Scott Anderson notifications@github.com wrote:

I don't know Grafana very well, but I know Chronograf has a feature that lets you view raw data. I'm curios to see what the actual values are in the erred data points.

— You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub https://github.com/influxdata/docs.influxdata.com/issues/2822#issuecomment-627387317, or unsubscribe https://github.com/notifications/unsubscribe-auth/AIXEAONZOMKE4EDSIY2CWGLRRFNRXANCNFSM4M4EMQ4Q .