Solved

Combined filter searching like '%string with spaces%'

  • 2 July 2019
  • 1 reply
  • 97 views

Userlevel 2
Badge +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?
icon

Best answer by Anne Buit 2 July 2019, 17:11

View original

1 reply

Userlevel 7
Badge +5
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