Hi,
I’m currently using PI SQL DAS with a template-specific data model (e.g.,GetSampledValues) to retrieve data. However, my requirement is to obtain only the exact archived values at specified timestamps.
In PI Web API, this can be achieved by setting
retrievalMode=exact
, which returns the archived value if it exists at the given timestamp, or indicates "No Data" if there is none.
Is there a similar functionality or configuration available in PI SQL DAS that allows us to:
- Retrieve only archived values that exactly match the specified timestamp
- Avoid interpolation or synthetic rows when no archived value exists
- Optionally return “No Data” if no exact match is found
Thanks for advice