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'