Table of Contents

Filter

The Filter query operator filters the dataset. When you select this option, select the column to filter, specify the filter method (e.g. equals, greater than, etc.) and the value to use as a filter. The available filter methods depend on the type of data in the selected column. Once the filter has been fully configured, you can refine the results by applying another operator, e.g. an additional filter.

From DataMiner 10.2.0/10.1.3 onwards, instead of specifying an exact filter value, use the available data in the dashboard as the column filter. Prior to DataMiner 10.3.5/10.4.0, you can do so using the Use feed checkbox. In more recent DataMiner versions, you can instead click the link icon to the right of the value box. Depending on the type of data, you will then 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 (from DataMiner 10.3.0 [CU21]/10.4.0 [CU9]10.4.12 onwards) or Query rows (from DataMiner 10.2.0 [CU2]/10.2.4 onwards) 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.

An additional option, Empty data shows, is available, which allows you to select what should be shown in case the field is empty: nothing, empty values only, or the full table ("everything"). Prior to DataMiner 10.3.0 [CU21]/10.4.0 [CU9]/10.4.12, this option is called When feed is empty, show. From DataMiner 10.1.11 up to 10.2.10/10.3.0, the option Return no rows when feed is empty is available instead. When you select this option, in case the feed is empty, an empty table will be returned instead of the entire table.

Note
  • Index data are only supported from DataMiner 10.2.0/10.1.5 onwards.
  • If the regex or not regex filter method is used, and data is used, from DataMiner 10.1.2/10.1.5 onwards, if the data contains multiple values, these are combined with an "or" operator.
Improve this page