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

RELATED IDEAS

Get Table with parameters

It would be very helpfull if we can pass parameters when we get Table data. Something similar to AFSDK's AFTable.GetTableWithParameters(param) https://techsupport.osisoft.com/Documentation/PI-AF-SDK/html/M_OSIsoft_AF_Asset_AFTable_GetTableWithParameters.htm
  • ADMIN RESPONSE
    Aug 23, 2022
    This feature will be available in PI Web API 2018.
  • Attach files
  • Guest
    Reply
    |     Aug 23, 2022
    Looking at the functionality, AFSDK seems to retrieve the entire AF Table rows even though we intend to query just a single row. If the server have a huge table, this is time consuming and it might be wonderful if we can directly query the table with a SELECT FROM WHERE query statement.
  • Guest
    Reply
    |     Aug 23, 2022
    This would be hugely useful for integration with a "Table" widget in PIVision. Eg to list work orders for an "Asset" or time relative searches. There are heaps of use cases for mashing up record data with process data.
  • Guest
    Reply
    |     Aug 23, 2022
    YES! I was just about to request this feature before I found this. I think this is an excellent idea, as CameronLee stated this would be awesome for a PI Vision 'table' symbol. We could create linked tables in AF and then pass run-time parameters to it based on the element/attribute values. This would be great!
  • Guest
    Reply
    |     Aug 23, 2022
    Yes, my use case is for known queries so I would know the parameters beforehand. Would I have to specify all parameters or if one is omitted, it will take the default value?
  • Guest
    Reply
    |     Aug 23, 2022
    @gonmerciel - Still in development & subject to change, but this is an excerpt from the work in progress... "Table Parameters are optional for all actions that accept them. Any parameters provided to PI Web API that are not configured in the table definition are ignored. If parameters that are configured in the table definition are not provided, then the configured default value is used."
  • Guest
    Reply
    |     Aug 23, 2022
    Sounds great, yes we would know the parameters beforehand. Would we be able to specify the parameter and it's value in PIVision?