PI SQL Client to make use of the RecordedValue method and Retrieval Modes for the GetValue transposed function
When making use of the GetValue transposed function when creating a new Template specific Data Model, we can see that under the hood it makes us of the AF SDK call AFData.InterpolatedValue method to capture the data at a specified timestamp provided in the transposed function. This method does make use of any Retrieval Modes.
It would be good for this GetValue transposed function to make use under the hood of the AF SDK call AFData.RecordedValue method instead since this method offers the possibility of using Retrieval Modes like "AtOrBefore" which is really useful to capture the last archived value before the timestamp provided.
This would provide a more faithful aspect of the behavior of the process.
Idris Lazuardi commented
Really need this feature, please. The old OLEDB enterprise provides it (although slow)