Skip to Main Content
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.

Status No status
Categories PI SQL Client
Created by Guest
Created on Aug 23, 2022

Add support for nested SELECT statements in PI SQL (RTQP)

The current version of PI DAS (RTQP Engine) does not support nested SELECT statements. This is a rather dire oversight, given that the older PI OLEDB Enterprise query engine does support nested SELECT statements. A very useful application of nested SELECT could be to centralise some arguments in SQL Views of their own, such as calculated start and end dates of time ranges.
  • Attach files
  • Bodo Bachmann
    Reply
    |
    Mar 28, 2024

    I assume that this is about subqueries in the SELECT list and/or in the WHERE clause.
    We have reviewed this idea, and it’s not something we plan to implement at this time. Even though we are declining this idea for now, it is still open to comments. We do want to hear your opinion. Thank you for the feedback, and please, keep sharing!

    Please share your use case and how this feature would help you.