Deleting tag history

Ignition
1

Hi!
Please, help.
How to delete history data for tags which were deleted?

2

I don’t normally bother with deleting tag history for tags that were deleted. But if you want to do that, it is best to go to the sqlth_te table first and find the id of the tag(s) you are going to delete. Then you go to your history tables ‘sqlt_data_…’ and run a query that looks like this…

delete from sqlt_data_… where tagid = [put the tag id in here]

This will delete all rows of historical data for that tag in that history partition table.

Again… this is not recommended. It is easy to make a mistake and delete history you want to keep!

Good luck!!

Walker

3

[quote=“wdreynolds1”]I don’t normally bother with deleting tag history for tags that were deleted. But if you want to do that, it is best to go to the sqlth_te table first and find the id of the tag(s) you are going to delete. Then you go to your history tables ‘sqlt_data_…’ and run a query that looks like this…

delete from sqlt_data_… where tagid = [put the tag id in here]

This will delete all rows of historical data for that tag in that history partition table.

Again… this is not recommended. It is easy to make a mistake and delete history you want to keep!

Good luck!!

Walker[/quote]

Thanks, will test.