Datagrid2 text filter with dropdown - Mendix Forum

Datagrid2 text filter with dropdown

0

Hi, I am working on datagrid2 and i need text filter with drop down, As for the drop down we are using there will be 60+ options and it would be difficult to scroll each time. But i can see that datagrid2 dropdown won’t have a text search option. Is there any way to add this type of filter for the datagrid2? Thanks in advance.

asked
2 answers

The latest version of Data Widgets provides the functionality you are seeking. Drop down filters in Data Grid 2 now have a text search/filter option.

image.png

 

image.png

 

ps you may wish to recategorise this post from 'Idea' to 'Question'

Created

You're right,

There are a few workarounds to solve this while keeping usability in mind, especially when dealing with a large list of 60+ options.

 

1. Use Reference Selector + Text Box Instead of Drop-down Filter

  • Create a data view (outside or above your DataGrid2) with a non-persistent helper entity.

  • Add a Reference Selector with search enabled for your 60+ options.

  • Add an on-change microflow/nanoflow or listen to widget, and filter the data source of your DataGrid2 based on this selection.

This gives you full control, and you get search + dropdown together.

 

2. Use List View with Manual Filters (Advanced Use Case)

If you're open to changing the component:

  • Switch from DataGrid2 to a List View or Gallery.

  • Build your custom filters with reference selectors, text inputs, and buttons.

  • Combine filters in a custom XPath or nanoflow to load the filtered list.

This is more effort, but gives you complete control and a better UX

Created