[Feature] A Proper filter type for columns with type select

[abah19vo]

[Feature] Add Proper Filter Type for Columns with "Select" Type in PlutoGrid

Feature Description

Currently, PlutoGrid supports filtering on its columns; however, for columns with the type select, the filtering mechanism could be improved to offer a more intuitive and user-friendly experience. This feature request proposes adding a specialized filter type for select columns to allow users to choose from predefined options directly.

Problem Statement

• Filtering select columns currently relies on generic filter mechanisms, which may not leverage the pre-defined options effectively.
• Users have to manually input values for filtering, which can lead to errors, such as mismatching cases or typos.
• The current experience is less efficient, particularly when the list of select options is extensive.

Proposed Solution

• Introduce a dropdown or similar UI component in the filter menu for select columns.
• Populate the dropdown with the pre-defined options specified for the select column.
• Allow multi-select functionality (if applicable) to filter by multiple options at once.
• Ensure the filter respects the case sensitivity or insensitivity defined by the grid's settings.

Expected Outcome

• A more user-friendly filtering experience for select columns.
• Reduced user errors when filtering.
• Increased efficiency, especially for columns with a large set of pre-defined options.

Additional Notes

• This feature should be backward compatible with existing PlutoGrid implementations.
• Consider allowing customization for dropdown style or behavior (e.g., single-select vs. multi-select).

Implementation Ideas

1. Extend the PlutoGridColumnType to include a dedicated filterType for select columns.
2. Create a dropdown filter widget tied to the column's select options.
3. Integrate this filter into the filtering logic of PlutoGrid to ensure proper handling of selected values.

Priority

Medium

Labels

feature-request, enhancement, usability

Let me know if you want to include more technical details or examples!

[github-actions]

This issue is stale because it has been open for 30 days with no activity.