Question:
How can I perform a query with numeric or text filters to an Elipse SCADA’s Historic?
Solution:
By default, Elipse SCADA’s queries only allows date filters. However, to work around this limitation, these filters can be performed via scripts.
To do so, you must create a secondary Historic, and also a RAM tag for each column in the main Historic. The script executing the filter must scan the main Historic, applying the desired filter to it. If the current line applies to the filter, it will be inserted in the secondary Historic. Thus, the secondary Historic will contain all data from the main Historic that satisfy the conditions of the applied filter.
To perform a new query, you must first erase the secondary Historic, and only then repeat the procedure.
Attached to this article is a sample application illustrating the procedure above.
Attachments:
