3 Replies Latest reply on Oct 28, 2013 11:12 PM by brooksey

    Process Book


      Does anyone know how to display the name of an AF element in a Process Book as an Element Relative item.  PB allows me to select all the defined attributes (calc's, points) but not the name of the element.  I tried creating an attribute and assigning the %Element% to the the attribute but it will not allow me to use a Pi Point, Table Lookup or <None> Data Reference.  Is there a way to display this?

        • Re: Process Book
          Marcos Vainer Loeff

          Hello Garth,


          The best solution I can think of is to create an AF Table linking to the table of PI OLEDB Enterprise that stores all the name of the elements in the database. Please, use the query below:



          SELECT Name FROM [Database Name].[Asset].[Element]



          Then, choose the Table Lookup Data Reference pointing to this new table using the query below in the Configuration String of the attribute that would store the name of the element:



          SELECT Name FROM ElementNames WHERE Name = '%Element%'



          In order to improve the performance, you can copy and paste the result of the first query on a new AF Table. In this case, the AF Table wouldn’t be linked to the tables of the PI OLEDB Enterprise, improving the performance. The down side of this option is that you need to add a new entry every time a new element is created.


          Another option would be to develop a custom data reference that would return the name of the element of the chosen attribute.