Skip to main content
Solved

Combined filter searching like '%string with spaces%'

  • July 2, 2019
  • 1 reply
  • 100 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!).
View original
Did this topic help you find an answer to your question?
This topic has been closed for comments

1 reply

Anne Buit
Community Manager
Forum|alt.badge.img+5
  • Community Manager
  • 637 replies
  • 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!).

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings