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 Declined
Product AVEVA™ PI System Access (PSA)
Categories PI OLEDB Driver
Created by Guest
Created on Aug 23, 2022

RELATED IDEAS

Specify Negative Time Offsets in SQL Commander

Customer would like to write a query to return a time column with a negative offset in the PI OLEDB Provider such as: SELECT time, (time - 1d) as datekey FROM piarchive]..[picomp2] WHERE tag='sinusoid' This query works SELECT time, (time + 1d) as datekey FROM piarchive]..[picomp2] WHERE tag='sinusoid' A similar query can be written using a linked server but requires the additional overhead of a sql server or ssms. SELECT time, DATEADD(day, -1, time) as datekey FROM [PI_DA].[piarchive]..[picomp2] WHERE tag='sinusoid'
  • ADMIN RESPONSE
    Aug 23, 2022
    Thank you for your feedback. Unfortunately, this feature is not a priority at time, so I am setting the status to declined.
  • Attach files