PI Developer Technologies

Welcome to the PI Developer Technologies feature suggestion box. 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, suggestions and feedback.

Please suggest your most important features and design change ideas on this site! Also vote for your favorite features now! We welcome your feedback.

  • NOTE: for documentation feedback and bugs, please report to Documentation@osisoft.com rather than entering 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. 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
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  PI ODBC Driver  ·  Flag idea as inappropriate…  ·  Admin →
  2. 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
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  PI Web API  ·  Flag idea as inappropriate…  ·  Admin →
  3. 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.

    2 votes
    Sign in
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →
  4. 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
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  PI AF SDK  ·  Flag idea as inappropriate…  ·  Admin →
  5. 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
    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 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.

    4 votes
    Sign in
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  General  ·  Flag idea as inappropriate…  ·  Admin →
  7. 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
    Signed in as (Sign out)

    We’ll send you updates on this idea

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

    2 votes
    Sign in
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  PI Web API  ·  Flag idea as inappropriate…  ·  Admin →
  9. 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.

    2 votes
    Sign in
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  PI AF SDK  ·  Flag idea as inappropriate…  ·  Admin →
  10. Option to verify PI Data Archive connection during PI SDK installation

    During PI SDK installation, there is currently no option to verify the connection to the PI Data Archive. This can lead to complications if, for example, PI Interface Configuration Utility (which includes PI SDK) is the first piece of PI software installed on the machine and an invalid PI Data Archive name has been entered during the installation. Because there is no verification in the installer, the PI SDK and anything that relies on the Known Servers table entry such as interface.bat files must be corrected post-installation.

    1 vote
    Sign in
    Signed in as (Sign out)

    We’ll send you updates on this idea

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

    2 votes
    Sign in
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  PI Web API  ·  Flag idea as inappropriate…  ·  Admin →
  12. 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
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  PI Web API  ·  Flag idea as inappropriate…  ·  Admin →
  13. Add support for AFFile type

    To support reading/writing files stored in AF. Read is more important though.
    Started from here: https://pisquare.osisoft.com/thread/37635-access-pdftextdoc-files-from-af-server

    I want to be able to use AF as a one-stop place to access my Asset Data. Therefore i want to be able to access Files stored in AF to provide this data alongside all other data through the PI Web API.

    2 votes
    Sign in
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  PI Web API  ·  Flag idea as inappropriate…  ·  Admin →
  14. Powershell - Add the ability to get Attributes or Elements by Category

    Add the ability to retrieve Attributes and Elements by category for Powewhell command-lets.

    Example 1:

    $cat = Get-AFCategory -Name "Product A Manufacturing" -Element -AFDatabase $afDB

    get-AFElement -category $cat -AFDatabase $afDB

    Get a list of all the elements in category "Product A Manufacturing"

    Example 2:

    $cat = Get-AFCategory -Name "KPIs" -Attribute -AFDatabase $afDB

    Get-AFAttribute -category $cat

    Get a list of all attributes in category "KPIs"

    0 votes
    Sign in
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →
  15. af sdk PIPointQuery should allow multiple use of filter name per AND condition, so ranges can be searched

    Currently the PIPointQuery cannot contain a filter condition with same filter name twice per AND condition of the query string.

    PointId:>5 AND PointId:<10.

    This would cause an error.

    Therefore filtering for a certain range is annoying as both result lists then have to be compared for common elements, workaround for the AND in above condition.

    Enhancement:

    Introduce a "BETWEEN" operator for the filter condition.

    Allow multiple use of filter names in the same AND condition.

    4 votes
    Sign in
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  PI AF SDK  ·  Flag idea as inappropriate…  ·  Admin →
  16. AF SDK Calls using the AFValues.GetValues should include an index of result events, this is to allow direct location of replacement events

    The PIPoint.ReplaceValues method requires a replacement of every event in the timerange, however it also may reorder or miss events with the same time stamp. The issue is that if the client wants to replace only a certain event, but must find that event - the replacement is for all the events at that timestamp and the method doesn't seem to allow for precise replacement of a value.
    The use case is programmatic correction of operator manual entry error, where multiple events have the same timestamp.

    2 votes
    Sign in
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  PI AF SDK  ·  Flag idea as inappropriate…  ·  Admin →
  17. Expose Values with Duplicate Timestamps in Transpose Function

    https://pisquare.osisoft.com/message/116957-pi-sql-commander-and-ssrs-how-to-retrieve-multiple-values-with-the-same-timstamp

    In the current implementation of the transpose archive in OLEDBEnt, a user is unable to retrieve data that may exist at the same timestamp as  another piece of data. This is because the time column is treated as the primary key of the transpose table. I would like to be able to retrieve all data using the archive transpose function regardless if timestamps are duplicated.

    5 votes
    Sign in
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  PI OLEDB Enterprise  ·  Flag idea as inappropriate…  ·  Admin →
  18. 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.

    2 votes
    Sign in
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  PI OLEDB Enterprise  ·  Flag idea as inappropriate…  ·  Admin →
  19. Add point attributes such as "instrumenttag" to "fields" for search controller

    Currently, as shown in the link below,

    https://techsupport.osisoft.com/Documentation/PI-Web-API/help/controllers/search/actions/query.html

    The "instrumenttag" as well as other PI point attributes are not selectable in "fields".

    The selectable ones are shown below:

    afcategory; attributes; datatype; description; endtime; haschildren; itemtype; links; matchedfields; name; plottable; starttime; template; uniqueid; uom; webid

    2 votes
    Sign in
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  PI Web API  ·  Flag idea as inappropriate…  ·  Admin →
  20. 1 vote
    Sign in
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  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