Skip to content

Filters

The "Filter by Column" feature allows users to apply various filters to data columns within the application. This feature is implemented in the filter options component, which provides a user interface for selecting fields, filter operations, and filter values.

Key Features

  • User-Friendly Interface: The filter options are displayed in a clear and intuitive manner, making it easy for users to apply filters.
  • Flexible Filtering: Users can filter data based on various operations such as Equals, Greater than, Less than, etc.
  • Real-Time Updates: Filters are applied in real-time, providing immediate feedback and results.
  • Multiple Filters: Users can add multiple filters to refine their data queries further.

Benefits

  • Improved Data Analysis: By allowing users to filter data columns, they can focus on the most relevant information, leading to better insights and decision-making.
  • Increased Efficiency: The ability to quickly apply and modify filters saves time and enhances productivity.
  • Enhanced User Experience: The intuitive interface ensures that users can easily navigate and utilize the filtering options without extensive training.

Adding a filter

To add a new filter, click on the "plus" icon under the filter options. This will open a new filter row where you can select the following filter options:

Field

  • Field: Choose the field you want to filter from the dropdown menu. Field
  • Filter: Choose the operation from the dropdown menu.

    The following filter operations are available:

    • Equals
    • Does not equal
    • Greater than
    • Less than
    • Greater than or equal to
    • Less than or equal to
    • Contains
    • Between Filter
    • Value for comparison: Input the value for the filter in the provided text box. Value

To update the filter, select a different option from any of the above field entries.

Note

  • Multiple Filters: Multiple filters are applied with the AND operator. This means the query will return only the data that meets all the filter criteria.
  • Dynamic Dropdown: The dropdown options in the filter is changed based on the data type selected in the fields. For example, if a numeric data type is selected, the dropdown will not include the "contains" option.
  • Unsupported Filters: Date or timestamp filters are not supported.

Applying a filter

To apply the filters, click the "Apply" button. This will validate the filters and execute the query if valid.

Removing a filter

To remove a filter, click the "delete" icon next to the filter row. This will remove the filter from the filter options.


Last update: December 5, 2024