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 documentation feedback and bugs, please report to Documentation@osisoft.com rather than entering them on this site.

How can we improve PI Developer Technologies for you?

(thinking…)

Enter your idea and we'll search to see if someone has already suggested it.

If a similar idea already exists, you can support and comment on it.

If it doesn't exist, you can post your idea so others can support it.

Enter your idea and we'll search to see if someone has already suggested it.

  • Hot ideas
  • Top ideas
  • New ideas
  • My feedback
  1. structured annotations oledb

    Have PI OLEDB work with structured annotations.Hopefully at the very least with String Type annotations.

    2 votes
    Sign in
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  PI OLEDB Driver  ·  Flag idea as inappropriate…  ·  Admin →
  2. 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
    Sign in
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  PI OLEDB Driver  ·  Flag idea as inappropriate…  ·  Admin →
  • Don't see your idea?

Feedback and Knowledge Base

Posted ideas will have one of the following statuses.
Full definition of these statuses can be found on the Home Page.
No status
NEEDS MORE DISCUSSION
RESEARCHING/EVALUATING
DECLINED
PLANNED
STARTED/IN DEVELOPMENT
IN BETA
COMPLETED