"contains" expression not returning partial words

Hi all,

My users need to search with the same search term across multiple fields from one datatype, cards.

I have a repeating group doing a search based on an input search bar on my page.
I understood that the “contains keywords” expression only returns full words, but “contains” should return partial words. As such, I set up the data source for the RG to read "Do a search for cards, with a constraint: “any field contains input search’s value”. But when I preview my app, the search pulls no results until the full word is entered.

See video for demonstration of bug.

https://youtu.be/YOuNH71zInk

Can anyone advise?

Thanks,

J

See set up here:

And filters:

Hello @thrillho welcome to the forum!

It seems that when using “any field” the expression works with full words only.

If you can repurpose the way that your object entries are saved … so that all words that are searched for can be saved in only one text field (used for searching) … things should work with partial words if you use “contains” with only this field.