With each HistorianTable, I want to trigger acording to 2 condition are period of 1 hour or quality change event of tags in each HistorianTable. But the trigger column is only one them. I also thought make a task script for my requirement, but I have many HistorianTables and each of them have many TagName.
So this is not possible.
Are there any solution for my requirement.
Set the Quality property of some tag you want at trigger configuration and set one hour (01:00:00.000) at time configuration. In expression configuration you have to increment the tag setted as trigger on HistorianTable. Compile the expression and the BuilsStatus must be ok.
Thanks for your Support.
In that way, I have to create expression for each table, isn’t it?
Because, I have more hundred table, so that way is not good.
Are there any better solutions?
Yes, in this scenario, you will need to create a separate expression for each table. To provide you with the best solution, I have a question that will help me better understand your needs:
You mentioned that you want to trigger based on two conditions: Firstly, after a one-hour period and secondly, when there is a change in the quality of the Tag. Can you please say what specific Tag you are referring to?
Are you going to use the same trigger for all tables? For example, when you save one table, you will save all 100 tables?
Also, why do you want to save the table when the Quality changes? Do you want to trigger the Table when the tag Quality goes from 192 to 0?
We develop an idea of code in C#, so you can use it as base to do what you described, you can use a Task to do that, it should be the more efficient way to resolve what you are looking for:
for (num of tables)
List GetHistorian("asdasd" + i)
Get (Tag +".Quality" != Estimate)
Estimate = GEt (Tag +".Quality")
flagSave = 1;
if (flagSave == 1)
In summary, the code appears to be querying a data historian system to check if the quality of a specific tag has changed since the last time the data was updated. If there is a change, the estimate is updated and the table is forced to update its data.