Filtering in a grid by reference is not easy if the list of options is quite large. E.g. for searching Orders by Product with such a data model:
You can either add a text filter - but then users already need to know what they are looking for - or you add a dropdown filter where you may need to scroll through a huge list to find the item you look for.
Can the Drop-down Filter for DG2 be extended to support autocompletion/filtering the selection list by entering a text, so that both features are combined?
Something like this is such a common function and should be available in Mendix out of the box:
Have a look here
https://docs.mendix.com/appstore/widgets/combobox/