Filter on Allowed values

This topic describes how to create filter queries on fields that present a list of predefined allowed values.

Selecting allowed values

Items with allowed values will present a Selection dialog box. The available items for selection can depend on location, configuration, permissions.

• Select one or values and click OK.

  

Allowed values in text box

After making selections on the selection box, the selected items will appear in the text box. This is editable.

Note When selected, string values appear inside double quotation marks, such as "Raw.Blasted Ore". These quotation marks are important, as they preserve any spaces included in the string value.

Syntax

These rules apply to the terms in filtering text boxes.

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

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

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

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

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

For more information about filtering on the Downtime-specific fields: Cause, Classification, and Effect, see Filter Downtime events.

Related topics

• Create a data query with Filter

• Filter on Boolean values

• Filter on Dates