Skip to main content
Right now you can make cool lookups which works with the 'Suggestion contains" control working as follow:



The thing I'm looking for right now is to achieve the same thing in the combined filter of that table, if you hit the lookup, but when i look search for "4022 635 9" in the combined filter, it will search as:

code:
where (((((t1.[artikel_en_oms] like '%4022%')))
  and (((t1.[artikel_en_oms] like '%635%')))
  and (((t1.[artikel_en_oms] like '%9%')))))


I want to achieve:
code:
where (((((t1.[artikel_en_oms] like '%4022 635 9%')))



Changing the filter condition in subjects -> data -> filter does not work.
Is there a way to achieve this?
Hi Tom,

The Windows GUI will search for exact matches when using quotes. This might be a bit of an undocumented feature.

Try searching for "4022 635 9" in the combined filter (including quotes!).
Terms & ConditionsCookie settingsAccessibility statement