Create custom filters and use filter favorites

You can select which records are included in your query results. For example, you can select a filter by the date of a record or the state of the alarm. You can select multiple fields to limit or expand your query results.

If you do not define a custom filter, all records are returned.

If you translated strings for language switching, you cannot use those strings as filter criteria. Translated strings are stored outside of the alarm database.

Create custom filters

1. Right-click the Alarm DB View control and then select Properties. The AlmDBViewCtrl Properties dialog box appears.

2. Select the Query Filter tab.

   

3. In the left pane, select filter fields and then select Add to include them in the filter, which is shown in the right pane. The filter fields are described in the following table:

   Field name	Filters query by:
   State	Alarm state. For more information, see Values for the State column.
   Class	Alarm class.
   Type	Alarm type.
   Priority	Alarm priority.
   Name	Alarm name.
   Group	Alarm group name.
   Provider	Alarm provider.
   Value	Alarm value. Values in the Value column are shown as alphanumeric values. The comparisons of these values in the Query Filter are done as string comparisons.
   Limit	Alarm limit. Values are alphanumeric. The comparisons of these values in the Query Filter are done as a string comparisons.
   Operator	Operator.
   OperatorFullName	Operator’s full name.
   OperatorNode	Operator’s node name associated with the alarm.
   OperatorDomain	Operator’s domain name associated with the alarm.
   Comment	Alarm comment.
   User1	Alarm user-defined numeric value 1.
   User2	Alarm user-defined numeric value 2.
   User3	Alarm user-defined string value.
   Duration	Unacknowledgement and alarm duration. A Duration column set equal to zero does not produce records with a null value in the query.

4. To remove a field from the filters pane, select the field you want to delete and select Delete. Deleting a filter cannot be undone. When a message appears, select Yes.

5. Configure the criteria for each filter field. For more information, see Define the column filter criteria.

6. Configure the operators and grouping for the filter. For more information, see Group alarm columns.

7. Configure the query favorites file. Do the following:

   1. In the Filter Favorites File box, type the network path and file name or select the ellipse button to browse for the file.

   2. To edit the Filter Favorites file, select the Edit Favorites File button. The Filter Favorites window opens, allowing you to add, modify, or delete filters from your favorites file. When you are done, select OK to save your changes and close the window.

8. Select Apply.