Hello,
I have a question for expert at WinCC OA.
Can I edit data point value that were added to archive using SQL request for example?
Is there any way for that?
Edit data point value
- adaneau
- Posts:310
- Joined: Tue Feb 21, 2012 9:49 am
Re: Edit data point value
Hi,
First of all, for data integrity you should never change an archived value. However it is possible that due to some errors, you want to manually correct it.
Here is the point, correct it. For this you can have a look into WinCC OA correction values, allowing you to add a correction value to an existing record. Then this value can be used instead of the initially recorded one (which will not be replaced nor deleted!).
If you are using NGA. I guess you can also eventually directly update into InfluxDB a field value (not tag!) but I wouldnt recommend it.
BR
Alexandre
First of all, for data integrity you should never change an archived value. However it is possible that due to some errors, you want to manually correct it.
Here is the point, correct it. For this you can have a look into WinCC OA correction values, allowing you to add a correction value to an existing record. Then this value can be used instead of the initially recorded one (which will not be replaced nor deleted!).
If you are using NGA. I guess you can also eventually directly update into InfluxDB a field value (not tag!) but I wouldnt recommend it.
BR
Alexandre
- MassEffect
- Posts:29
- Joined: Mon Aug 24, 2020 8:19 pm
Re: Edit data point value
Thank you for your answer! Please tell me, where can I find an extra information about "correction values"?