AVEVA™ PI System™ Feedback Portal

Welcome to our new feedback site!


We created this site to hear your enhancement ideas, suggestions and feedback about AVEVA products and services. All of the feedback you share here is monitored and reviewed by the AVEVA product managers.

To start, take a look at the ideas in the list below and VOTE for your favorite ideas submitted by other users. POST your own idea if it hasn’t been suggested yet. Include COMMENTS and share relevant business case details that will help our product team get more information on the suggestion. Please note that your ideas and comments are visible to all other users.


This page is for feedback specifically for AVEVA PI System. For links to our other feedback portals, please see the tab RESOURCES below.

ADD A NEW IDEA

PI SQL Client

Showing 20

RTQP 2023 SP1 SQL database execution script to be made available for download from customer portal

We might still need the SQL script because when the installer failed to run successfully for some reason, the SQL scripts won't be present. AF SQL database execution script used to be available to download from customer portal until version 2018 S...
Ee Sheing Lee 3 months ago in AVEVA™ PI System Access (PSA) / PI SQL Client 0 No Status

PI SQL Commander's Template-Specific Data Model Wizard should include a search/filter to make locating templates in the template selection step easier.

PI SQL Commander's Template-Specific Data Model Wizard should include a search/filter to make locating templates in the template selection step easier. Currently for AF databases with many templates, a user has to use a scroll bar in order to find...
Bethany Jewett 6 months ago in AVEVA™ PI System Access (PSA) / PI SQL Client 0 No Status

PI SQL Client to support all types of ResultSets

Currently the PI SQL Client JDBC only supports reading the resultset in a forward manner (ResultSet.TYPE_FORWARD_ONLY). We would like to have the feature to support all types of Result sets like ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.TYPE_SC...
Diwakar Hariharan 9 months ago in AVEVA™ PI System Access (PSA) / PI SQL Client 0 No Status

Access AFTables with RTQP

Add possibility to read AFTables using RTQP Engine
Carlo Pedroli about 1 year ago in AVEVA™ PI System Access (PSA) / PI SQL Client 0 No Status

Table-Valued Function

Currently it is not possible to define filter definitions for Table-Value functions.With DataLink I'm able to define to build an average for a process value by using a defined filter method. e.g. calculating an average current of an engine while t...
Christian Benitz over 1 year ago in AVEVA™ PI System Access (PSA) / PI SQL Client 0 No Status

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 provid...
Guest over 1 year ago in AVEVA™ PI System Access (PSA) / PI SQL Client 1 No Status

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 ...
Guest over 1 year ago in AVEVA™ PI System Access (PSA) / PI SQL Client 4 No Status

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 r...
Guest over 1 year ago in AVEVA™ PI System Access (PSA) / PI SQL Client 0 No Status

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 fun...
Simon J. Dyson over 1 year ago in AVEVA™ PI System Access (PSA) / PI SQL Client 0 No Status

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 u...
Guest over 1 year ago in AVEVA™ PI System Access (PSA) / PI SQL Client 5 No Status