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.

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. Add Annotations support for RTQP Engine

    I would like the RTQP Engine to be able to read annotations.
    My use case is the following :
    I have user that enter manual values into PI along with these values the operator will specify the reason for this manual input.

    The comment is stored in an annotations, there is currently no way to retrieve this information.

    Retrieving a string would be sufficient for my needs.

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

    We’ll send you updates on this idea

    0 comments  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →
  2. 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.

    11 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. Allow Creation of Acknowledgeable Event Frames

    The PI Web API exposes a "CanBeAcknowledged" property when reading Event Frames. However, this property is read-only: it cannot be supplied when creating a new Event Frame or updating an existing Event Frame. I would like the ability to include this parameter when creating an Event Frame.

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

    We’ll send you updates on this idea

    2 comments  ·  PI Web API  ·  Flag idea as inappropriate…  ·  Admin →
  4. Import-AFXml (PowerShell) should have ContinueOnError option

    Both AFImport.exe and ImportXml (AFSDK) have options to continue on error (like is something is checked out or if there is a duplicate element name). For some reason the PowerShell version doesn't. This should be added.

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

    We’ll send you updates on this idea

    0 comments  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →
  5. Write annotations on archive data via PI Web API

    My client is interested in writing annotations to Stream (time series) data via the PI Web API. I know it's possible to pull this data via the ?associations=annotations query parameters but the write feature is missing.

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

    We’ll send you updates on this idea

    0 comments  ·  PI Web API  ·  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.

    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 →
  7. PI SQL Commander usability suggestions

    To make things easier for the user, please consider doing the following:
    • Move the contents of View, Query, Tools, and Help from the menu bar into the toolbar. This will reduce the click count from 2 to 1, and the toolbar has more than enough room to accommodate some additional buttons, especially when the window is maximized.
    • Add the keyboard shortcuts to the tooltips of the buttons in the toolbar.
    • Label more of the toolbar buttons so that the user does not have to hover over each button to know what each button does.
    • Eliminate the…

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

    We’ll send you updates on this idea

    0 comments  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →
  8. Expose Business Integrator statistics via AF SDK

    It will be nice feature addition in AF SDK, usability and publications management will also increased.

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

    We’ll send you updates on this idea

    0 comments  ·  PI AF SDK  ·  Flag idea as inappropriate…  ·  Admin →
  9. Expose UOM Groups in PI Web API

    As a programmer I want the PI Web API to expose an endpoint for reading UOM Groups and UOM Group mappings. This would allow javascript based web applications to read the UOM Groups and mappings in order to use the mappings in subsequent data stream requests. Then the end users could see all data in familiar UOMs according to their selected UOM Group.

    UOM Groups was introduced in PI AF 2017 R2 and is supported in AF SDK 2.9.5+.

    The endpoint could e.g. be at
    https://host/piwebapi/assetservers/{assetServerId}/uomgroups/ and https://host/piwebapi/assetservers/{assetServerId}/uomgroups/{groupId}/mappings/

    A similar request exist under PI Vision product and maybe they can…

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

    We’ll send you updates on this idea

    0 comments  ·  PI Web API  ·  Flag idea as inappropriate…  ·  Admin →
  10. Add more date and time functions to PI SQL Client

    As a PI SQL Client OLEDB user, I would like to have the TIME(), DATE(), LOCALDATE() and TOLOCALDATE() functions available in order to construct datetimes for my queries.

    These functions were available in PI OLEDB Enterprise, but are not available in PI SQL Client OLEDB.

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

    We’ll send you updates on this idea

    0 comments  ·  General  ·  Flag idea as inappropriate…  ·  Admin →
  11. Don't install SQL Commander Lite with OLEDB Drivers Automatically

    We did install the SQL Client software on our SQL server, but there was no option to exclude the SQL Commander Lite. So, we had to turn around and uninstall SQL Commander Lite. I'd just like to suggest for future install packages that there be an option to exclude SQL Commander Lite.

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

    We’ll send you updates on this idea

    0 comments  ·  PI OLEDB Driver  ·  Flag idea as inappropriate…  ·  Admin →
  12. allow search where name contains space to return determinant results

    querying for names which contains spaces is non-determinant. AFSDK has methods to search on name, but webapi OR's the search. For results sets which should contain one or few rows, this can result in thousands of wasted rows.

    PI Query syntax EBNF specifies quotedescapedchar, which includes Char, so space should be honored.

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

    We’ll send you updates on this idea

    0 comments  ·  PI Web API  ·  Flag idea as inappropriate…  ·  Admin →
  13. PROBLEMA NA ATUALIZAÇÃO PI JDBC 2017-2018

    Problemas encontrados na atualização da versão 2017 para 2018.

    Quando a biblioteca de conexão tenta acessar tal funcionalidade ocorre a excessão "PreparedStatement#addBatch() is not implemented yet".

    Problema similar ocorre com o uso da opção setReadOnly que deixou de ser suportada na versão 2018 do driver. Quando
    o método abaixo é invocado uma excessão é lançada o que causa problemas na nossa implementação. Talvez uma solução
    seja adicionar uma mensagem de warning como a realizada no método setTransactionIsolation.

    public void setReadOnly(boolean readOnly) throws SQLException {
        throw new SQLFeatureNotSupportedException("setReadOnly() is not supported by PI JDBC Driver.");
    }

    public void setTransactionIsolation(int level)…

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

    We’ll send you updates on this idea

    0 comments  ·  PI JDBC Driver  ·  Flag idea as inappropriate…  ·  Admin →
  14. Provide programmatic interface to manage OMF applications

    Enable Create,Read, Update, Delete operations for OMF applications via an API so that the process is standardized and efficient/effective as opposed to manual and error prone, especially for larger numbers of apps.

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

    We’ll send you updates on this idea

    0 comments  ·  PI Web API  ·  Flag idea as inappropriate…  ·  Admin →
  15. Support DST Transition on Second Granularity in PI SDK

    A user tries to retrieve date with timestamp 03-Nov-2018 23:59:59 (1 second before Daylight Saving Time beginning) in PI SMT, but the returned event has a timestamp of 04-Nov-2018 00:59:59. This is because PISDK timezone design is such that it can only transition DST on minute granularity, and the Windows TZ info for Brazil says the transition is at 23:59:59 so PISDK truncates the seconds for the transition rule.

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

    We’ll send you updates on this idea

    0 comments  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →
  16. PI ODBC driver for linus

    There is a pi JDBC driver for linux, but not an ODBC driver. This means that tools built around ODBC do not fully exploit the tools functionality. For example, RStudio has great database navigation tools that require ODBC.

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

    We’ll send you updates on this idea

    0 comments  ·  PI ODBC Driver  ·  Flag idea as inappropriate…  ·  Admin →
  17. Have Status of an analysis

    I would like to have status of analysis (Enabled, Disabled, Running, Error or Warning) via PI AF SDK with the attribute 'Status' or the method 'GetStatus'.
    In the library, we already have in AFStatus all the Status declared but not used.

    Thanks to that it will be possible to see all analysis in error and try to resolve analysis in error with AF SDK.
    Morever, We won't do backfilling on analysis in error and create other error, it will be clean to do backfilling on all analysis Enabled if we know which analysis are in error.

    Sorry for my english…

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

    We’ll send you updates on this idea

    1 comment  ·  PI AF SDK  ·  Flag idea as inappropriate…  ·  Admin →
  18. Reset Attribute to Template method in PI Web API

    Synced to PI Square at https://pisquare.osisoft.com/ideas/29447

    As a developer using PI Web API, I would like to have a Reset an attribute to template method using the Web API so I can program with greater flexibility.

    I am attempting to create a .NET Core App and this limitation prevents us from using PI Web API exclusively in automated AF Builds

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

    We’ll send you updates on this idea

    0 comments  ·  PI Web API  ·  Flag idea as inappropriate…  ·  Admin →
  19. AF SDK and Web API on Linux OS'es

    With Microsoft supporting .NET Core on Linux operating systems such as RHEL, SLES Ubuntu, CentOS, and Debian.
    https://docs.microsoft.com/en-us/dotnet/core/about
    https://docs.microsoft.com/en-us/dotnet/core/linux-prerequisites?tabs=netcore2x

    They are even supporting SQL Server on Linux OS'es.

    I don't know the dependencies of the AF SDK nor the Web API, but if they can use .NET Core; it would be nice to have the AF SDK and Web API available for Linux based OS'es.

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

    We’ll send you updates on this idea

    1 comment  ·  PI AF SDK  ·  Flag idea as inappropriate…  ·  Admin →
  20. Missing Open API (Swagger) specification for the Search controller

    The swagger specs for the search controller are not available. This will be useful in the client libs for searching

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

    We’ll send you updates on this idea

    0 comments  ·  PI Web API  ·  Flag idea as inappropriate…  ·  Admin →
← Previous 1 3 4 5
  • 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