AVEVA™ PI System™ Feedback Portal

Welcome to our 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 Subscribe
Status No status
Product AVEVA™ PI System Access (PSA)
Categories PI SQL Client
Created by Simon J. Dyson
Created on Aug 23, 2022

RELATED IDEAS

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 the top n results in a table in applications such as PI Vision.
  • Attach files