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.

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

    We’ll send you updates on this idea

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

    11 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 →
  3. 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 →
  4. Allow Direct PI Data Archive Server exposure

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

    8 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. 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.

    7 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 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 →
  7. Include overridden attributes of derived templates in Event Frame View with PI SQL DAS (RTQP)

    When you create a template-specific event view, event frames based on derived templates are also returned. However, attributes which are overridden in the derived template return empty. This means more complicated queries using UNION ALL must be used.

    As a user, when I use a derived template with an overridden attribute, it is often because I need to change the way that attribute is calculated in a subset of cases. However, I still want to be able to create a view easily for all of this data.

    For example, I have a "Batch" template with "Pounds Produced". However, for a…

    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 →
  8. Provide a PI SQL Commander Lite Standalone Download

    Currently, PI SQL Commander Lite is bundled with PI SQL Client, PI OLEDB Enterprise, and PI ODBC Driver.

    It is a very useful tool for PI OLEDB Provider, which does not bundle it. To use it, another provider needs to be installed to obtain PI SQL Commander Lite indirectly.

    The version of PI SQL Commander Lite that is bundled with each provider is the latest version of PI SQL Commander Lite at the time of the provider's release. This means that the latest versions of each provider could have different versions of PI SQL Commander Lite bundled with them.

    Manageability…

    2 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 →
  9. 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 →
  10. 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 →
  11. Allow Direct PI Data Archive Server exposure

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

    1 vote
    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 →
  • 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
TELL US MORE
EVALUATING
PLANNED
IN DEVELOPMENT
COMPLETED
DECLINED