Filter string with spacing

[zdf43907]

I have…

• [X ] Read the following guideline: https://docs.squidex.io/01-getting-started/installation/troubleshooting-and-support. I understand that my support request might get deleted if I do not follow the guideline.

I’m submitting a…

• [ ] Regression (a behavior that stopped working in a new release)
• [X ] Bug report
• [ ] Performance issue
• [ ] Documentation issue or request

Current behavior

I would like to search the name that contains spacing within the word, like as below:
Filter = $"contains(data/name/en, ‘Peter Joe’)

And here are the data in name:
Peter Don Joe
Sam Chai

Expected behavior

The result should return Peter Don Joe

is there any handling for the wildcard search?

Minimal reproduction of the problem

Environment

• [ ] Self hosted with docker
• [X ] Self hosted with IIS
• [ ] Self hosted with other version
• [ ] Cloud version

Version: [VERSION]

Browser:

• [ X] Chrome (desktop)
• [ ] Chrome (Android)
• [ ] Chrome (iOS)
• [ ] Firefox
• [ ] Safari (desktop)
• [ ] Safari (iOS)
• [ ] IE
• [ ] Edge

Others:

[Sebastian]

Hi, the expression is actually converted to regex, you can just try to use a regex term for “Peter Jon”, something like Peter[\s]+Jon or so

[zdf43907]

It’s not work for me, if the data have 3 or above words like Peter Jon Doe, I type Peter Doe will expect it will return Peter Jon Doe, but no luck.

[Sebastian]

Perhaps you are looking for full text search using $text?

[zdf43907]

Yes, but I solved the issue with the statement below:

$filter=contains(data/name/en, 'peter.*doe')

Thanks for your help.