Array Values in PI Vision
It would be nice to have a possibility to Display AF Array Attribute Values within PI Vision. At the Moment we try to Display the results of a SQL table lookup with one or more results in PI Vision. Due to the dynamic amount of results, it is not possible to use one Attribut per result.
Bryan Klosiewicz commented
My oil and gas customer has a similar use case to the comment from SaroshG. They would like to display multiple rows from an AF linked table showing the previous work orders for a given compressor asset. Currently this is very clunky to display in PI Vision as you would have to look at linked a fixed number of rows from the array to individual AF elements. If the number of rows is dynamic (ie - Number from * back to 1/1/18) then it would potentially cut off anything more than the number of elements.
To add to this, I'd like to be able to display array values w/in X-Y Charts
We have PI AF attributes referencing a SQL table look up, but the attributes can have multiple values so they are returned as an array of values. At this time we do not know how to display the attributes or use them in analytics. The attributes contain the status or type of open maintenance work orders for a piece of equipment.