Skip to main content
Answer

Combined filter searching like '%string with spaces%'

  • July 2, 2019
  • 1 reply
  • 109 views

Tom van Druten
Warrior
Forum|alt.badge.img+6
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?

Best answer by Anne Buit

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!).
This topic has been closed for replies.

1 reply

Anne Buit
Community Manager
Forum|alt.badge.img+5
  • Community Manager
  • Answer
  • July 2, 2019
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!).