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 Frederik Reinhard
Created on Mar 13, 2025

RELATED IDEAS

Enable Table-Valued Functions to use parameters more than once

Currently Table-Valued Functions only support the use of a parameter once. For example, once the parameter has been used in another table Valued function like:

...
crossapply Master.Element.GetSummary

<...> (e.ID, @StartTime, @EndTime)

I am not able to use it in another function or "where" statement.

This is frustrating as in complex query's I might need to join or cross apply several functions ans subquery's that all need the same parameter as input. Currently the only way around this is to pass the same parameter several times and distribute the single parameters to the different functions that require it.

  • Attach files
      Drop here to upload