"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.

Can anyone advise?



See set up here:


You can try this nifty Regex approach.