Filter string with spacing

I have…

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


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

Version: [VERSION]


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


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

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.

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

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

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

Thanks for your help.

1 Like