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: Choose the field you want to filter from the dropdown menu.
-
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
- Value for comparison: Input the value for the filter in the provided text box.
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.