Feature Request: Keep search input visible and add debounce when menuLimit is exceeded in filter dropdowns

[harshAliter]

Problem:

Currently, the pivot table has a menuLimit prop that restricts the number of items shown in filter dropdowns. If the number of options exceeds this limit, both the list and the search input are hidden, making it impossible to filter large datasets. Additionally, the search input lacks debounce logic, which can cause performance issues when typing with large datasets.

Proposed Solution:

• Even when the number of options exceeds menuLimit, display the search input so users can search and select items.
• Add debounce to the search input to improve performance when filtering large datasets.

Benefits:

• Makes filtering usable for large datasets.
• Maintains performance optimizations by not rendering the full list.
• Aligns with common UX patterns in other UI libraries.
• Reduces unnecessary computations and improves responsiveness during search.

Additional Context:
This change would enhance usability and performance, allowing users to efficiently filter even when the dataset exceeds menuLimit.

Hi! This is my first time contributing a feature request here. I’m happy to provide more details or clarify anything if needed. Thanks for considering this suggestion!