Filter Downtime events

Downtime and Energy events have some unique fields for identifying the location and impact of plant floor events.

You must first specify the Cause location, and then configured allowed values lists for Cause, Classification, and Effect will become available.

To create a Downtime query in the Filter Builder

This topic describes how to create a filter query for Downtime events in the Filter Builder.

1. Select the Downtime module in the Select Module panel.

   

2. On the toolbar, click Filter Records. The Filter Records dialog box appears.

To filter on Cause Location

• Click Cause Location to open the Filter on Cause Location dialog box. Select the specific locations in the plant hierarchy where the Downtime event occurred. For example, if one piece of machinery is broken, this could be a very specific location. However, if power for the entire plant went down, then this might be an entire site.

  

  After selecting the cause locations, the location names will appear in the text box. This field is editable.

  

  Note When selected, string values appear on the Filter form inside double quotation marks, such as "Enterprise.Coal Site 2". These quotation marks are important, as they preserve any spaces included in the string value.

Syntax for location fields

These rules apply to special fields that contain a location, such as Cause Location.

• [Location] with recurse enabled.

• Wildcards ("*" and "?") are supported, but not in conjunction with "with recurse".

• You cannot use >, >=, <, <=

• Location searches are case-sensitive.

Syntax for Cause, Classification, Effect

These rules apply for the special fields of Cause, Effect, and Classification.

• You can use AND and OR operators to combine locations.

• The ID of each can be used interchangeably with its text.

• You cannot use >, >=, <, <=

• You cannot use wildcards ("*" and "?")

For more information on operators, see Filtering rules for String values.

To filter on Cause field

The Cause field provides a selection box to select the relevant cause code. You can select multiple allowed values.

Note The list may not appear in alphabetical order due to combining multiple lookup lists. Multiple lists will group in their original lists and display one after the other.

3. Click Cause to open the Cause Filter Selection dialog box.

4. Select one or more Causes that apply to this event.

5. Click OK.

   

   Note When selected, string values appear on the Filter form inside double quotation marks, such as "Process Control". These quotation marks are important, as they preserve any spaces included in the string value.

To filter on Classification field

The Classification field provides a selection box to select the relevant classification. You can select multiple allowed values.

6. Click Classification to open the Classification Filter Selection dialog box.

7. Select the Classification for the Cause. For example, the cause might belong to Electrical classification of failure, or Cleaning classification.

8. Click OK.

   

   Note When selected, string values appear on the Filter form inside double quotation marks, such as "Not Scheduled". These quotation marks are important, as they preserve any spaces included in the string value.

To filter on Effect field

The Effect field provides a selection box to select the relevant effect. You can select multiple allowed values.

9. Click Effect to open the Effect Filter Selection dialog box.

10. Select the Effect produced by the Downtime event. For example, the effect might be Operating Jam that resulted from malfunctioning equipment.

11. Click OK.

    Note When selected, string values appear on the Filter form inside double quotation marks, such as "Operating Jam". These quotation marks are important, as they preserve any spaces included in the string value.

Related topics

• Create a data query with Filter

• Edit details of Downtime event

• Use cause codes and relationship matrixes