Create an alarm filter
Filter the alarms to display only certain alarms at runtime. Create a text box to filter the displayed alarms.
Prerequisites
To create an alarm filter
- Place a Text box on the editor.
- In Project view, expand AlarmGrid (type) and select the AlarmsDataGrid object.
-
In Properties, in Query, select
Add Dynamic Link.
- In Dynamic Links, expand AlarmGrid(type) and select Query.
- Choose Select.
-
In Properties, in Query type the query.
Tip: Type a variable right into the query such as SELECT * FROM Table1 WHERE Column1 > 5, where 5 is the variable. Enter a placeholder for the variable such as SELECT * FROM Table1 WHERE Column1 > {0}, where {0} is the variable. For example, in a system consisting of several machines, to filter the alarms by MachineID, the query to display the alarms for MachineID = 001 could be SELECT * FROM Model WHERE MachineID=001.