Skip to content

Manual filter

Insight offers special user-input to filter conversion support in various places. By using the supported filter variants, a user can search for specific data more efficiently. This feature is currently supported in the filter text boxes above Insight Tables and in FilterPopups (used in Insight Table and Insight Gantts).

Supported filters: - Regular text: - Input test will filter for test - This filter takes the searchPattern configuration into account - Open date ranges: - Input >2020 will filter for all years after 2020 - Input >=2020 will filter for all years after 2020, including 2020 - Input <2020 will filter for all years before 2020 - Input <=2020 will filter for all years before 2020, including 2020 - Closed date ranges: - Input 2020~2021 will filter for all years from 2020 to 2021 - Single date: - Input 2020 will filter for the year 2020 exactly - Numerical ranges: - Input >20 will filter for all values greater 20 - Input >=20 will filter for all values greater 20, including 20 - Input <20 will filter for all values lower 20 - Input <=20 will filter for all values lower 20, including 20 - Not equals: - Input !=test will filter for all values that do not match test

All date filter variants support the following patterns: - l, DD/MM/YYYY, DD.MM.YYYY, YYYY-M-D, DD.MM.YYYY HH:mm - M/YYYY, M.YYYY, YYYY-M - YYYY