Table of Contents

Filter

The Filter query operator filters the dataset.

When you select this option, follow the steps below:

  1. Select the column to filter.

  2. Specify the filter method (e.g., equals, greater than, etc.).

    The available filter methods depend on the type of data in the selected column.

  3. Specify the value to use as a filter. You have two options:

    • Enter an exact filter value manually in the Value field.

    • Link to data by clicking the Link to data icon (previously called Use feed).

      This lets you use available data from the dashboard or app as the column filter. Depending on the type of data, you will need to specify the following information:

      • Data/Feed: The name of the data (component, URL, variable, etc.). If only one data entry is available, it will automatically be selected.

      • Type: The type of data that needs to be selected. If only one type of data is provided, it will automatically be selected. The type Tables (previously known as Query rows) allows you to link the filter to rows from another query, if a compatible query is available.

      • Property: The property by which the column will be filtered (depending on the type of data).

        If Type is set to Tables/Query rows, instead of a property, you can select the columns from the table containing the query rows. However, note that you will only be able to select columns that are compatible with the type of column you are filtering.

      • Empty data shows: Select what should be shown in case the data used as a filter has no valid values: nothing, empty values, or everything (i.e., the full table). Prior to DataMiner 10.3.0 [CU21]/10.4.0 [CU9]/10.4.12, this option is called When feed is empty, show. Note that an empty string is considered a valid value. If an empty string is provided, it will be used as the filter value.

  4. Optionally refine the results by applying another operator, such as an additional filter.

Note

Prior to DataMiner 10.5.0 [CU13]/10.6.0 [CU1]/10.6.4, or when the SLHelper process is used for GQI operations instead of the GQI DxM, multiple filter values are not handled as a true "or" filter:

  • If the regex or not regex filter method is used and the data contains multiple values, these values are combined into a single regular expression using an "or" operator. This only works for string values.
  • Other filter methods (for example contains or equals) only apply the first value. Any additional values are ignored.
Improve this page