Merge old tag history with rename new tag history

Ignition Version 8.1.2
I create a tag and config it history. SQL ID is 5051.
Later I rename this tag on 2022-10-19 . SQL ID is 5188.
When I query Chart ,I just see the new tag chart.
I can't query the old tag and rename new tag chart together.
How to merge them together?

Hi taohongyu88,

Please reach out to support regarding merging old tag history with new tag history. You can reach us here Support Home Page | Inductive Automation

Best,

To be fair, merging of tag history due to a rename or move shouldn't require support to help with this. This should really be something that can easily be done by an integrator.

@taohongyu88 you just need to change the tagid of all of the relevant records in your sqlth_data_x tables to the new tag id.
PS. If the above doesn't make sense and you don't know what you're doing in SQL, you could end up destroying all of your tag history. In which case a support call is probably recommended.

E.g.
For:

Execute this below to re-map your old history to the new tag:

UPDATE
	sqlt_data_5_2022_11
SET
	tagid = 5262
WHERE
	tagid = 5261

ENSURE YOU HAVE A "WHERE" CLAUSE AND THAT IT IS CORRECT before executing that UPDATE query
Excluding a WHERE clause will re-map all history in that table to your new tag.
Using the wrong WHERE clause may have equally catastrophic consequences