How can I use a "Contains" filter on a column with a lookup?
I have a column with a lookup that shows the “Name” value. I have set the Filter to “Contains”. In my filter it does stick with “Equal to”.
Lookup
Filter conditionU-GUI filter form result
If I now try to search for component that have “Engine” in the name, I cannot get this result:
Filter box
Grid snippet with component names that I wish to see by only using Contains “Engine”
Tried with several lookup controls, but does not seem to enable the option. How can I make it change to “Contains”?
Usage: Platform 2025.2
Page 1 / 1
Hi Mark,
Thanks for your question.
Please take a look at the filter update from the 2025.2 release.
Although the solution does not work for the Filter Form (which I assume you are using at the moment), it does work with the filter that is available in the action bar which will open a filter popup.
You can change the filter setting "Visible for filter” from “Always” > "Extended”:
Set "Visible for filter” to “Extended”
This way you can add an extra filter field which filters the lookup table in a way similar to what you want to achieve. I will post some screenshows below, but note that the lookup column in my example is called maddress]:
Add extra filter for lookup fieldAdd a condition to the lookup fieldUse the "Contains” operator in a field from the lookup table
I hope this helps. Please let us know if you have any additional questions.
Best regards,
Nick Janssen
@Nick Janssen That does indeed give us an option to get to a “contains” method.
From a user perspective this does over complicate things. They just see a “name” value and wish to filter that. Having to go deeper, just because it is a lookup seems a bit much.
I am all for the option that you can use it to also filter on other columns of the lookup, but not being able to use “contains” for the actual lookup value seems a bit much.
Is this a feature that will come back though (filtering with “contains” directly in the used screen)?
We are attempting to make users use the actual column they wish to filter by making the filter form available instead of using the less efficient search (combined) filter, so this hurdle would not really help us for that.
@Mark_Plaggenborg Agreed that this is too cumbersome for users and that is something we should improve. Could you raise a ticket in TCP for it?
@Arie V I have raised a ticket in TCP: 13325S
In relate to the solution Nick provided above.
Because you wish to filter on multiple values (this is what a contains filter does), the IN operator is also usefull. Search for dropdown items does the contains filter and the user can select multiple items in the same filter action.
Note the grid header filtering uses this mechanism too, which is the easiest way for users to access this type of filtering.
I agree on Arie we have to make this better accessible for users without the need of opening the filter popup.
We will do the follow-up on the ticket.
@Erik Brink Thanks for the additional explanation. The IN method will have its use in certain cases and I am happy with its availability.
I’ll await the change so also “Contains” will become an option again, so searching for partial matching is also possible.