PI Developer Technologies

Welcome to the PI Developer Technologies feedback page!  

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, feature suggestions and feedback. Please suggest your most important features and design change ideas on this site, and vote for your favorite ideas.

Please note that your ideas and comments posted here are visible to all other users.

  • For bugs, please open a case with OSIsoft Tech Support through myOSIsoft Customer Portal  (https://my.osisoft.com) instead of sharing them on this site.
  • For documentation feedback and bugs, please report to documentation@osisoft.com instead of sharing them on this site.

  • Hot ideas
  • Top ideas
  • New ideas
  • My feedback
  1. Expose Event Frame Annotations in PI SQL DAS (RTQP Engine)

    I would like the ability to access event frame annotations using PI SQL Client, in the same way as in PI OLEDB Enterprise.

    19 votes
    Sign in Sign in with OSIsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    2 comments  ·  PI SQL Client  ·  Flag idea as inappropriate…  ·  Admin →
  2. 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…

    8 votes
    Sign in Sign in with OSIsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  PI SQL Client  ·  Flag idea as inappropriate…  ·  Admin →
  3. Be able to use RTQP to access PI Points and Config strings (DA Directly)

    Be able to use RTQP to access PI Points and Config strings (DA Directly)
    Use case:
    create a dashboard that lets me know the amount of bad data (tags) mapped to our AF.

    (eg. “Bad Input”, “Calc Failed”, etc)

    Our system has numerous tags and it is impossible to monitor them one by one.

    The RTQP engine has allowed us to query massive amount of AF Attributes to get their current values easily.

    Some AF attributes have been excluded in our system. For that case, we are not interested whether or not the values are bad.

    Hence I would like…

    6 votes
    Sign in Sign in with OSIsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  PI SQL Client  ·  Flag idea as inappropriate…  ·  Admin →
  4. Add element reference information to to RTQP tables.

    In OLEDB Enterprise, we could find element references by type.  Currently, this information is not exposed in RTQP.  It would be helpful to be able to identify which type of reference an element is using.  One use case is for PI Admin's to generate reports on element hierarchy to ensure the proper reference is being used by builders of the AF DB.  This is especially helpful in AF DBs where element references are used to build multiple "views" using the same elements and the reference type could be used in conjunction with the new IsPrimaryPath column for reporting.

    5 votes
    Sign in Sign in with OSIsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  PI SQL Client  ·  Flag idea as inappropriate…  ·  Admin →
  5. Allow Direct PI Data Archive Server exposure

    Extend the capability of PI SQL Client to connect directly to PI Data Archive Server

    4 votes
    Sign in Sign in with OSIsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  PI SQL Client  ·  Flag idea as inappropriate…  ·  Admin →
  6. Add data reference impersonation for value retrievals

    When retrieving values for attributes, impersonating the user can enable the user of security at the data source level. For example, with a PI Point Data Reference attribute, it could allow the user's authorization to be user at the data archive rather than the PI SQL DAS (RTQP) service account doing the data retrieval.

    3 votes
    Sign in Sign in with OSIsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  PI SQL Client  ·  Flag idea as inappropriate…  ·  Admin →
  7. Return row number from PI SQL Client calls

    It would be useful to be able to access a specific row from a PI SQL Client call. For example if I query muiltiple attributes indicating some KPI ordered from highest to lowest returning 1000 rows, I might want to show only the top 10. The TOP function is supported in SQL Client, but the Table Lookup DR in AF only allows you to find the first row.

    It would be useful if either the row number, 1..n, was returned or the table lookup DR would allow you to pick a specific row. This would then allow you to show…

    1 vote
    Sign in Sign in with OSIsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  PI SQL Client  ·  Flag idea as inappropriate…  ·  Admin →
  8. Allow Direct PI Data Archive Server exposure

    Extend the capability of PI SQL Client to connect directly to PI Data Archive Server

    0 votes
    Sign in Sign in with OSIsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  PI SQL Client  ·  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/PREVIEW
COMPLETED