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

    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 →
  2. 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

    0 comments  ·  PI SQL Client  ·  Flag idea as inappropriate…  ·  Admin →
  3. 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 →
  4. Return Event Frame Attribute Values with GetEventFrames Method

    Currently the GetEventFrames method returns only the properties of the event frame (start time, end time, extended properties, severity, ect.). In order to get a table including the event frame attributes, you need to get the event frame list first and then go through each event frame to get the related attribute values.
    It would be helpful if the GetEventFrames function returned a snapshot of the event frame's attribute values to improve the speed of custom applications.

    0 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 →
  5. Be able to expose AF with PI OPC DA Server

    Today PI OPC DA can only expose tags from DA.
    To have the option to expose information from AF.
    Both the AF structure and attributes.

    We are using AF for everything so why not in PI OPC DA.

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

    We’ll send you updates on this idea

    0 comments  ·  OPC DA & HDA Servers  ·  Flag idea as inappropriate…  ·  Admin →
  6. Provide ability to specify ID (Guid) when creating elements or attributes

    Provide ability to specify ID (Guid) when creating elements or attributes in AF via the AF SDK.

    When replicating data from an external system to AF, we need to be able to use the same GUID that has already been established.  This will allow us to easily query data from PI Web API because the GUIDs can be directly translated into WebIDs without having to perform lookup queries first.

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

    We’ll send you updates on this idea

    16 comments  ·  PI AF SDK  ·  Flag idea as inappropriate…  ·  Admin →
  7. Add list of obsolete method/object in release note or help file for new releases

    Posted on behalf of a customer:
    Currently, we should go into method/object details page in order to check if the method/object is obsolete. Documenting this as a list should help any application developers to know the changes clearly.

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

    We’ll send you updates on this idea

    0 comments  ·  Help / Documentation / Videos  ·  Flag idea as inappropriate…  ·  Admin →
  8. PI AF SDK Linux Support

    As we know there are 2 major competitor for cloud technologies that is Microsoft and Linux destros. If we want to use Linux docker image or PCF Linux image to connect AF SDK, we don't have any provision for this as of now because AF SDK does not support Linux OS. If we support this then most of cloud customer attracts to use AF SDK in their organization.

    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. There are no java samples on git to access PI web API

    We are building java client to access PI server via PI web API . we can not see nay sample on git on java to access it. Can you please help us.

    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. Allow conditions in Batch Controller

    I would like to be able to have conditionals in my requests to the batch controllers.
    Consider this use case : I want to create an element and its parent, but the parent may already exists.

    At the moment, I have to make 2 seperate calls: One to check if the parent exists. Then a use the appropriate batch requests to create only the child or create both the parent and child

    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 →
  11. Rebuild Index is not working as expected

    In the https://pivision-us.oxy.com/piwebapi/admin/search/database.html page the Rebuild Index button does not work. It should allow the pi vision administrator to immediate re-indexing of individual AF database at the time without affecting the usability of the others.

    4 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 →
  12. 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 →
  13. 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 →
  14. 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 →
  15. 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.

    5 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 →
  16. 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 →
  17. 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 →
  18. 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 →
  19. 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 →
  20. 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 →
← Previous 1 3 4 5 6
  • 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