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 24

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

TransposeArchiveEX feature on RTQP

No description provided
Guest over 1 year ago in AVEVA™ PI System Access (PSA) / PI SQL Client 1 No Status

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

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

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

Add RTQP PI SQL support for parameter type cast

PI DAS (RTQP Engine) 2018 SP3 Patch 1 lacks support for type casting input parameters of a table valued function. For example. this simple example fails to create a table valued function: CREATE FUNCTION [MOMS].[fact].[getInstrumentOperationalDat...
Guest over 1 year ago in AVEVA™ PI System Access (PSA) / PI SQL Client 0 No Status

Add RTQP PI SQL support for default value of function parameter

The current version of PI DAS (RTQP Engine) does not support the definition of default values for table-valued function parameters. This is a rather bleak omission, in my view. For example, the following will fail to create the table-valued functi...
Guest over 1 year ago in AVEVA™ PI System Access (PSA) / PI SQL Client 0 No Status