Filter search results
- Last UpdatedOct 04, 2024
- 2 minute read
- PI System
- PI Server 2018
- PI Server
Procedure
-
In Filter Expression, type an expression using Performance Equation (PE) syntax.
-
In Show Filtered, select a filtering option:
-
Show Filtered Values: Substitute Filtered as a placeholder for each event or block of events filtered, based on the filter expression.
-
Remove Filtered Values: Remove filtered events from the list, showing only events that do not match the filter expression criteria.
-
Use Expression Times: Return all data including and between start and end times. This is the default setting. This may be affected by how you define a boundary type.
-
-
Click the Get Events button
.
Example of filter expression using Performance Equation (PE) syntax
In this example, to filter the results to show only the events where the temperature (represented by the tag TempSensor) is above 75°F and the equipment status (represented by the tag EquipStatus) is running (represented by the value 1), use the following filter expression:
TempSensor > 75 AND EquipStatus = 1
Procedure
-
Enter a filter expression.
In the Filter Expression field, type the following expression:
TempSensor > 75 AND EquipStatus = 1
-
Select a filtering option.
-
Show Filtered Values: This replaces each event or block of events that match the filter criteria (TempSensor > 75 and EquipStatus = 1) with the placeholder Filtered.
-
Remove Filtered Values: This removes the events that match the filter criteria from the list, showing only the events where the temperature is 75°F or below, or the equipment status is not running.
-
Use Expression Times: This returns all data including and between start and end times where the filter expression criteria are met.
-
Retrieve filtered events
Click the Get Events button
to apply the filter and retrieve the filtered search results based on the selected
filtering option.
Explanation
-
TempSensor > 75: This part of the expression filters events where the temperature is greater than 75°F.
-
AND: This logical operator ensures that both conditions on either side of it must be true for an event to be included in the filtered results.
-
EquipStatus = 1: This part of the expression filters events where the equipment status is running.