Filter by event frames

The following procedure shows how to apply an event frame row filter to an asset view.

Note: Filtering by event frames applies only to asset views.

When you define an asset shape, you create a collection of matches that meet the same criteria. When you apply an event frame filter to this view, you define an event shape that creates a collection of matches for a set of event frames. The PI Integrator then joins these two collections based on a common asset to obtain the subset of data that matches both.

For example, assume you have a number of wells where a certain piece of equipment is run one at a time at each well, and event frames are used to record the data collected by this equipment. Each event frame has a different start and end time and applies to a different well. You can use the event frame row filter to include asset view data for the well only for the period that the equipment was running on that well.

1. On the My Views page, select the view that you want to modify and click Modify View. Then click Next to open the Modify View page.

   Note: If you are already on the Modify View page, skip to the next step.

2. Use the Start Time and End Time fields to adjust the time range to include the times when the event frames of interest were recorded.

   Note: If the start and end times are outside the event frame time range, no event frames will be found.

3. Click Edit Row Filters and choose Event Frame for the type of filter.

   The PI Integrator now searches for event frames on your PI AF database for this view and displays a subset of the ones it finds.

   

4. Click the icon to open the menu. Click the right-angle bracket (>) on one of the filtering categories to open the related panel.

   

   In the filtering fields, specify parameters to narrow down the event frames to find the ones you are looking for. For example, enter a pattern-matching string in the Event Name field or select a template in Event Template.

   

5. Click Apply Filters.

6. From the event frames found, drag an event frame to the center pane.

   The filter now includes rows for which this event frame is active.

7. Optionally, you can broaden the row filter search criteria to include all event frames with the same template or category. To do this, use the drop-down list to change the search from Event Name to Event Template or Event Categories.

   

8. Click the icon next to the event condition.

   The PI Integrator fetches matching event frames and shows them in the preview pane at the bottom of the window.

9. To align the event frames with the correct asset, drag the asset or attribute from the Shape Tree onto the filter criteria.

   This step defines the relationship between the two data sets (the event frame data set and the asset and attributes data set). This is similar to the clause in a relational table join that equates an attribute in one table (or dataset) to an attribute in the other table (dataset). Here, we are equating the asset "owning" the event frame to the asset from your Shape Tree.

   The PI Integrator updates the display of matching event frames in the preview.

10. When you have finished defining the filter, click Save Event Frame Row Filter.