PI Developer Technologies
Welcome to the PI Developer Technologies feature suggestion box. This forum covers the PI AF SDK, PI Web API, PI OPC DA and HDA Servers, and the PI SQL family. We created this forum to hear your ideas, suggestions and feedback.
Please suggest your most important features and design change ideas on this site! Also vote for your favorite features now! We welcome your feedback.
- NOTE: for bugs, please report to OSIsoft Tech Support at https://techsupport.osisoft.com/My-Support/My-Cases/New/ rather than entering them on this site.
- NOTE: for documentation feedback and bugs, please report to Documentation@osisoft.com rather than entering them on this site.
-
structured annotations oledb
Have PI OLEDB work with structured annotations.Hopefully at the very least with String Type annotations.
2 votes -
Specify Negative Time Offsets in SQL Commander
Customer would like to write a query to return a time column with a negative offset in the PI OLEDB Provider such as:
SELECT time, (time - 1d) as datekey
FROM piarchive]..[picomp2]
WHERE tag='sinusoid'This query works
SELECT time, (time + 1d) as datekey
FROM piarchive]..[picomp2]
WHERE tag='sinusoid'A similar query can be written using a linked server but requires the additional overhead of a sql server or ssms.
SELECT time, DATEADD(day, -1, time) as datekey
FROM [PI_DA].[piarchive]..[picomp2]
WHERE tag='sinusoid'1 vote
- Don't see your idea?