We are using a RDMBS interface to pull data from a SQL view that from my limited understanding is configured periodically based on the scan class in location 5. The data in the SQL view can change for timestamps that have passed.
E.g. Timestamp: 10-Jan-24 12:00:00 AM, Value: 100
We've noticed that if the value change happens on the current day, our query picks up the correct value and the PI Point shows the latest value. However, if the value for say a timestamp from 2 days ago changes, PI does not recognise the change.
Is there a way of identifying changes to past timestamps and overwriting the values at those timestamps?