Use comparison operators with delta retrieval
- Last UpdatedMar 19, 2025
- 1 minute read
The system behaves differently when doing typical delta-based queries where a start date and end date are specified using the comparison operators >=, >, <= and <. The comparison operators can be used on the History and WideHistory tables. The comparison operators also apply regardless of how the query is executed (for example, four-part naming, OLE DB provider views, and so on).
Delta queries that use the comparison operators return all the valid changes to a set of tags over the specified time span. Using deadbands and other filters may modify the set of valid changes.