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!).

Reply


Terms & ConditionsCookie settings