Skip to main content

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 condition
U-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

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 field​​​​​
Add a condition to the lookup field
Use 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.

Reply


Terms & ConditionsCookie settings