Add filters

You can add one or multiple filter criteria to filter the values of the PPM query.

The PPM data source operator supports user inputs of List type as input parameter. Thus, widgets using the PPM operator allows the use of multiple selection. That means that you can select one or multiple values in another widget to filter values provided by the PPM data source operator. To enable multiple selection when using the PPM operator, you must assign at least one user input of List type as input parameter. You can select Date user input (List) and Text user input (List) as input parameter. Number user input (List) is currently not supported by the PPM operator.

For details on creating input parameters, see the chapter Create input parameters.

Procedure

  1. In the PPM operator, click Add filter.
  2. Select a dimension or measure, such as Date or Process cycle time, and click Add. The selected criterion is added to the PPM operator as a filter criterion.
  3. Select an operator for the condition of the filter criterion in the drop-down menu, for example, is equal to.

    For criteria of Text type, the is equal to operator is available by default. If you enable filtering by expressions, the starts with, ends with, and contains operators are additionally provided. For enabling filtering by expressions, see step 5 below.

    For criteria of Date type, the operators On, Before or on, and On or after operators are available. The Before or on and On or after operators cannot be used with Date user input (List).

  4. Enter a constant filter value in the input field, or click Insert parameter Insert input parameter and select an input parameter. The button can only be clicked if there is at least one input parameter with the same data type as the filter criterion.

    To enable the multiple selection for the PPM operator, select a user input of List type as input parameter.

  5. You can filter criteria of Text type by expressions instead of entire words. For example, if you use a place holder in the filter expression, for example, * or ?.
    1. Click the Operator condition Set filter properties icon and specify the filter parameters.
    2. Enable the Filter using an expression uses.
    3. Select whether the Key or the Description of the criterion is to be used as filter value.

      If you enable filtering by expressions, further operators are provided to set the filter condition. See step 3 above.

  6. Click Add condition (+) to add further filter conditions.

    If you add further filter condition, the AND-link conditions option is displayed. You can enable the option to link the filter condition with a logical AND. By default, the conditions are linked with a logical OR.

  7. Click Delete condition (-) to remove a filter condition.

Your settings are applied.