We have the following issue with historical sqltags.
In our development workflow, we need to very often delete and recreate sqltags with the same full tags paths.
when tag are recreated new id are generated for historical tag definition in sqlt_te table.
So old historical data which are binded to old id are lost.
We would like when tag are recreated that old ids are reused in sqlt_te instead of creating new ids.
Is there a way to do that or to make a sync between realtime historical definition and sqlt_te table ?
I suppose unique id for one tag path is the only way to be able to query all tag history from easy chart
No
It’s seem that id are not recreated for the same tag path, when tag are deleted and recreated if the history db is well connected during these action.
perhaps the case occur when history db is disconnected when tag are deleted ? or when tag are recreated ?
I feel like you shouldn't be having this issue. If the tag is being recreated with the exact same path in the same historical provider on the same machine then the system should still see and return the old historical data from before you deleted and recreated. I have seen on rare occasions the old tagid still used to store data after it's been retired , but in that scenario you don't see any new data.
What version of Ignition are you currently running?