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 OLEDB Enterprise access to AF Tables

    Allow PI OLEDB Enterprise access to AF Tables.  The current workaround is to have the table live on a SQL database and then link to them from AF.

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

    We’ll send you updates on this idea

    0 comments  ·  PI OLEDB Enterprise  ·  Flag idea as inappropriate…  ·  Admin →
  2. Automatically update Transpose Function in SQL Commander when referenced Element Template name is updated

    In PI SQL Commander, users can create Transpose Functions that are linked to Element Templates in AF. When the referenced Element Template is renamed in PI System Explorer, the Transpose Function in PI SQL Commander is no longer able to find the Element Template which breaks the Function and underlying Data Table.

    Users are not aware that the Transpose Function or the underlying Transpose Data Table are broken until they attempt to query the Table or Transpose Function.  It would be ideal if the Transpose function could either update this reference automatically or if the function referenced the GUID of…

    4 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 →
  3. Add in the Element Hierarchy table information to determine the primary reference of a copied reference element

    When an element is copied as reference (parent-child) elsewhere in the tree it then has multiple parents. One of it is the primary parent. This information needs to be added to the hierarchy tables.

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

    We’ll send you updates on this idea

    1 comment  ·  PI OLEDB Enterprise  ·  Flag idea as inappropriate…  ·  Admin →
  4. Improve AF Search PI AF SDK with ORed option

    PI AF SDK - Search Query Syntax - Filters

    Allow results to be ORed. Currently Results can only be ANDed.

    4 votes
    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 →
    PLANNED  ·  Chris Manhard responded

    This is planned for the 2018 R2 release for AF based searches. Note that while the user interface in PSE will allow OR clauses to be typed in, there will not yet be a user interface in 2018 R2 to help you build OR clauses.

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

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

    3 votes
    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 →
  7. 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 →
  8. Add support for AFElement Versions

    Add support for AFElement versions to PI Web API.
    1. Create a new Element Version by defining the effective date and an optional version comment. 2. Add Get and Find methods which support querying AFElements by setting a QueryDate.
    See also https://pisquare.osisoft.com/message/122510-re-how-to-create-a-new-af-element-version-with-pi-web-api and https://pisquare.osisoft.com/message/59027

    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 →
  9. Schedule PI Web API Crawls

    The customer would like the ability to schedule crawls for a specific AF database (it's quite large), so that crawls don't interrupt users who need to access the elements in the PI Vision search during their working hours.

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

    We’ll send you updates on this idea

    1 comment  ·  PI Web API  ·  Flag idea as inappropriate…  ·  Admin →
  10. Return Partial Results From Event Frame Search in PI Web API

    Currently when searching for event frames, a 400 error is returned if not all elements in the search exist.

    piwebapi/eventFrames/search?databaseWebId=WebId&Element:IN("\server\AssetSwap\Site2\Asset1";"\server\AssetSwap\Site2\Asset2"

    This is cumbersome especially in the case of asset swapping in PI Vision when parent elements could contain variable child elements. For any parent element that contains less than the max child elements, a 400 error will occur when searching for event frames for related parent elements.

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

    We’ll send you updates on this idea

    1 comment  ·  PI Web API  ·  Flag idea as inappropriate…  ·  Admin →
  11. Allow PI OLEDB Enterprise client to specify which member of a PI Data Archive Collective to connect to.

    Enable functionality for PI OLEDB Enterprise that will allow the client to specify which member of a PI Data Archive collective they wish to connect to. This functionality has already been enabled for PSE and would like something similar for PI OLEDB Ent.

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

    We’ll send you updates on this idea

    0 comments  ·  PI OLEDB Enterprise  ·  Flag idea as inappropriate…  ·  Admin →
  12. Support Performance Equation Syntax for time parameters in the PI Web API

    As a Web API developer, I would like to be able to use time PE functions in the Web API using the streams/streamsets controller to allow for complex time queries.

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

    We’ll send you updates on this idea

    1 comment  ·  PI Web API  ·  Flag idea as inappropriate…  ·  Admin →
  13. Get Values by Count in the PI Web API

    As a PI Web API developer, I would like to retrieve values by specifying a count like you can do in PI SMT and other PI clients. This functionality is exposed by the RecordedValuesByCount in the AF SDK.

    3 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 →
  14. Add 'Time Zone = Server' to PI OLEDB Enterprise

    'Time Zone = Server' is available in PI OLEDB Provider, but has not been added to 'PI OLEDB Enterprise'.
    We have PI Data Archives in multiple time zones and require the ability to select the data in the server time zone.

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

    We’ll send you updates on this idea

    1 comment  ·  PI OLEDB Enterprise  ·  Flag idea as inappropriate…  ·  Admin →
  15. Mention in the AF SDK reference documentation that exception is not applied by the UpdateValues method

    The UpdateValues method does not implement by itself the exception mechanism. Exception is applied on the client side, for instance by UniInt interfaces.

    As a developer,  I would like this fact to be mentioned in the documentation to avoid confusion:
    https://techsupport.osisoft.com/Documentation/PI-AF-SDK/html/MOSIsoftAFDataAFDataUpdateValues1.htm

    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 →
    PLANNED  ·  Chris Manhard responded

    Documentation for methods PIPoint.UpdateValue(s) and PIServer UpdateValues will contain this note in 2017 R2.

  16. Add the “Create Timestamps” functionality back into the OPC DA Server product

    In the PI OPC DA/HDA Server 2010 product, there was a “Create Timestamps” functionality (found in the OPCServerConfig Tool). This option had the PI OPC Server create timestamps for OPC clients. I rely on this functionality heavily for an OPC client I use every day. Thus, currently I have to stay on PI OPC DA/HDA Server 2010 since this functionality was removed from the newer version. I would like to have this functionality back.

    3 votes
    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 →
    PLANNED  ·  Ray Verhoeff responded

    We understand this feature is important and we are planning to restore it. We will give you an update on the release schedule when this is finalized.

  17. Allow subscribing/unsubscribing to attributes on existing channel connection

    The channel/websocket feature of PI Web API would be more useful if it was possible to subscribe/unsubscribe to attributes on an existing channel connection. Currently you have to open the connection with all the WebIds you want in the resource URL. If you want to change which values you are receiving, you would have to close the connection and open a new one. Adding this new feature would also solve issues with maximum URL length limitations.

    3 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 →

    This is an issue we definitely need to address for both the reasons you suggested. We should be able to add and remove attributes while a channel is open. We also need a mechanism for signing up for large numbers of WebIds when the list would be too long for a URL.

  18. Windows authentication of clients

    As a PI user, I want the OPC DA and HDA Servers to honor the Windows identity of any connected OPC client.

    3 votes
    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 →

    We understand the requirement. It makes sense. We have been looking into it but it turns out to be difficult to do. We used a third-party framework to build the PI OPC DA Server which separates interactions with the OPC client from interactions with the PI Data Archive. It solved a number of problems but unfortunately there is no easy way to have OPC client user credentials flow to the PI Data Archive. We are evaluating our options.

  19. Allow Direct PI Data Archive Server exposure

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

    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 →
  20. 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 →
  • 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