I’m trying to make a tag history utility in Ignition to do a number of things, one of which is to copy history for tagA for a date range into another tagB. The problem is, tagB may already have its own tag history within the date range, so I need to delete this first before copying in the tagA data.
I could try to form a DELETE query, but the history could span multiple historic tables whose names I’m not sure how to construct… one example name is sqlt_data_3_2018_06 which is the history table for this current month (current date: 2018-06-21). Where does the ‘3’ come from and can i predict this name?
What’s the best way to do this?