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 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 function: CREATE FUNCTION [MOMS].[fact].[getInstrumentOperationalDataSummaries] ( @StartTime DateTime, @EndTime DateTime, @TimeStep TimePeriod, @TimeType String = 'MostRecentValue' ) AS SELECT i.* ,s.Value FROM MOMS.dim.InstrumentsBase i CROSS APPLY [MOMS].[fact].[Instrument Base Template_GetSummaries] ( i.ElementID, --Element ID @StartTime, --Start Time @EndTime, --End Time @TimeStep, --Time Step @TimeType --Time Type ) s It should not. It is most reasonable to wish to provide a default value for TimeType in the above example. And T-SQL supports it, just by the way.
  • Attach files