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 Server
Categories Asset Framework (AF)
Created by Guest
Created on Aug 19, 2022

RELATED IDEAS

Allow AF Enumeration Set as data type of column in AF Table

As a user, I want to be able to use AF Enumeration Set as a data type in a column of an AF Table, so that I can populate the column based on defined values in an AF Enumeration set.
  • ADMIN RESPONSE
    Aug 19, 2022
    Thank you very much for sharing your feedback on the PI Server. After further evaluation, we have decided to decline this item, as we are not planning on implementing it in the near future due to other high priority items across the PI System. Thank you for your feedback, and know that we are listening and reviewing every item that gets submitted!
  • Attach files
  • BradR
    Reply
    |     Aug 19, 2022
    Is it possible that there is a work around? If the table column is type Interger, will PI AF recognize the Interger value as a substitute for the enumerated value? Each enumerated value in an enumeration set is assigned a corresponding numeric value. For example, 1 = CAT, 2 = DOG, 3 = BIRD, etc. If the column/row contains a 3, will PI AF recognize that as BIRD if retrieved via table lookup into an attribute defined as an enumeration set?
  • Guest
    Reply
    |     Aug 19, 2022
    You can use a table with a column type of Int32. Add an AF table with 2 columns. Make the second column (ColumnName2) a value type of Int32. Add the following three rows to the AF table: ColumnName1 ColumnName2 str1 0 str2 1 str3 2 Add an AF enumeration set (Enum1) with the following values: {0, CAT}, {1, DOG}, {2, BIRD} Add an element that contains two attributes: Attribute1 and Attribute2. Set Attribute1's value type to Int32. Set Attribute2's value type to the AF enumeration set Enum1. Bind Attribute2 to a table lookup data reference with the following settings string (without the double quotes): "SELECT ColumnName2 FROM Table1 WHERE ColumnName2 = @Attribute1 ORDER BY ColumnName2" As Attribute1 is changed then Attribute2 displays the corresponding table entry that matches ColumnName2's value. This in turn will display the Name that matches the AF enumeration value. Note: make sure to refresh the Attribute2 after making a change to Attribute1.
  • Guest
    Reply
    |     Aug 19, 2022
    BTW, you can easily use ColumnName1 as the table lookup. Add another attribute, Attribute3, which is type of string. Add another attribute, Attribute4, which has a value type of Enum1. Bind Attribute4 to the Table Lookup data reference and set the settings string (without the double quotes): "SELECT ColumnName2 FROM Table1 WHERE ColumnName1 = @Attribute3 ORDER BY ColumnName1" Now change Attribute3 from str1 to str2 to str3, refreshing the attributes after each change. You'll get the results in Attribute4 as CAT, DOG, and BIRD, respectively.
  • Gael
    Reply
    |     Aug 19, 2022
    This could be used in many cases and not only for manual inputs (ex: settings retrieval such as thresholds based on tag status...). This could be only the string value of the enumeration. A feature to have!
  • Gael
    Reply
    |     Aug 19, 2022
    This could be used in many cases (ex: settings retrieval such as thresholds based on tag status...). This could be only the string value of the enumeration. A feature to have! Similar user voice: https://feedback.osisoft.com/forums/555148-pi-server/suggestions/36768184-allow-value-type-enumeration-sets-in-af-tables?_ga=2.106877891.1538329517.1585754786-431683007.1572527714
  • Guest
    Reply
    |     Aug 19, 2022
    We use AF-Tables for some manual data entry. This works pretty fine. In some cases it would make sense to give the user a pre-defined selection of values, so that the data alwas has the same format. So allowing Enumeration Sets in AF-Tables would be great.