Or when type "document old" , and still get result for "Old Document".

Case: For example, record in database is "Old Document", when user type "document old" in filter input, the filter will return the result "Old Document", because the keywords "document" and "old" are contained in the word "Old Document" in the record.

Hello Firdaus,
This could be achieved in the query builder, but you have to split the string and look word by word with contains operator. Use the split format like:

{{$_GET.search.split(" ")[0]}}
this will return the first word
{{$_GET.search.split(" ")[1]}} the second ... etc

You can also use the conditions there so the filter only applies if the word exists, like

{{$_GET.search.split(" ")[0]}}
condition field: {{$_GET.search.split(" ")[0]}}

{{$_GET.search.split(" ")[1]}}
condition field: {{$_GET.search.split(" ")[1]}}

{{$_GET.search.split(" ")[2]}}
condition field: {{$_GET.search.split(" ")[2]}}
etc.

with operator 'Contains' and 'AND'

Hi Teodor,

Thank you for this very useful tips.