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 Subscribe
Status No Status
Product AVEVA™ PI System Access (PSA)
Categories PI SQL Client
Created by Guest
Created on Aug 23, 2022

RELATED IDEAS

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].[getInstrumentOperationalDataStringOverload] ( @StartTimeIn String, @EndTimeIn String, @TimeStepIn String ) AS SELECT * FROM MOMS.fact.getInstrumentOperationalData( CAST(@StartTimeIn As DateTime) ,CAST(@EndTimeIn As DateTime) ,CAST(@TimeStepIn As TimePeriod) ) The following example fails in similar fashion: CREATE FUNCTION [MOMS].[fact].[getInstrumentOperationalDataStringOverload] ( @StartTimeIn String, @EndTimeIn String, @TimeStepIn String ) AS SELECT * FROM MOMS.fact.getInstrumentOperationalData( DateTime(@StartTime) DateTime(@EndTime) TimePeriod(@TimeStep) ) Error message: The table-valued function definition is not supported.
  • Attach files