Please ensure Javascript is enabled for purposes of website accessibility
Powered by Zoomin Software. For more details please contactZoomin

PI Builder (PI Server 2024 R2)

Retrieve elements with specific maintenance dates

  • Last UpdatedJan 11, 2023
  • 2 minute read

Before you can retrieve elements, you need to Edit the reactor elements to specify new attribute values.

You can use PI Builder to retrieve elements with specific attribute values into your worksheet. Follow this procedure to retrieve the reactor elements with last-maintained dates earlier than June 19, 2010.

  1. Open a new Microsoft Excel worksheet and click the PI Builder tab.

  2. Click Elements > Find Elements to open the Element Search window.

  3. If the field next to the Search button is not blank, then click to clear the text.

  4. Under Criteria, set the fields to find the desired element:

    1. From the Template list, select Reactor Template.

    2. From the All Descendants list, select True.

    3. Click Add Criteria and then click Attribute Value to add a set of fields that you can use to search by attribute value.

  5. In the Attribute Value field set, configure the query to find elements that have specific values in the maintenance-date attribute:

    1. Click Display attribute choices and then click Other Attributes > Manufacturer | Last Maintained.

    2. Set the operator field to the less-than sign (<).

    3. In the value field (marked <Null>), type 19 June 2010.

  6. Click Search.

    PI Builder returns four elements in the Results table.

  7. Select all the returned elements and click OK.

  8. In the Select Object Types and Column Headers window, select the objects and column headers that you want to appear in the worksheet.

    1. Click Clear All to clear any previously selected columns.

    2. In the Attribute Columns (from Template 'Reactor Template') group, select the Manufacturer | Serial Number check box.

  9. Click OK to retrieve the elements into the worksheet.

    The Retrieve Selected Objects window shows the operations completed.

  10. Click Close.

    The worksheet shows all the reactors that have a last-maintained date earlier than June 19, 2010.

TitleResults for “How to create a CRG?”Also Available in