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

    16 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

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

    14 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  PI SQL Client  ·  Flag idea as inappropriate…  ·  Admin →
  3. 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.

    9 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

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

    4 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

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

    4 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  PI SQL Client  ·  Flag idea as inappropriate…  ·  Admin →
  6. Get AF Server Name and AF Database Name in PI SQL DAS (RTQP)

    As a PI Applications Developer, I need to be able to retrieve the name of the current AF Server and Current AF Database in the PI SQL DAS (RTQP). This information was available in PI OLEDB Enterprise’s [System].[Connection].[ConnectionProperty] and [System].[Connection].[ConnectionStatus] tables. I would like it to be in PI SQL DAS (RTQP) as well.

    2 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  PI SQL Client  ·  Flag idea as inappropriate…  ·  Admin →
  7. Add support for unit conversion

    Please add a "Canonical UOM Per UOM" or "UOM Per Canonical UOM" column (not necessarily with those exact names) to the UnitOfMeasure table. This column would contain the conversion factor needed to convert between the UOM and the canonical UOM, similar to the "Canonical" column in PI System Explorer when you are viewing a UOM class.

    With this in place, a user can easily convert a value to any unit by first converting from the value's default UOM to the canonical UOM of the value's UOM class, and then convert from the canonical UOM to the desired UOM. This would…

    1 vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  PI SQL Client  ·  Flag idea as inappropriate…  ·  Admin →
  8. 1 vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

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

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  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