Searching functionality: "contains" operation

Hi, Bubblers.
I’m working on a search functionality for my end-users.

I have a Thing called “Sports”. And several entries in DB for that thing: football, basketball, tennis, hockey, etc.
On search page I have:

  • input field,
  • button to trigger a WF (send value from input field to repeating group),
  • repeating group (to display results of a search).

What I want to achieve: search for all sports whose name contains value entered in Search input (full name or just a part of it).
Example: user types “ball” and presses search button. In the repeating group all sports with “ball” (basketball, football) in their names should be displayed.

When I type in full name of a sport (football) - the search works and I can see football in my repeating group.
When I type only “ball” - nothing is found (nor “football”, nor “basketball”)

The expression for data source of a repeating group is: Do a search for a Sport where "sports_name contains search_input’s value"
So as I understand, “contains” operation should help us to look for Sport just by a part of a name.

Am I wrong?

Updated. Just found topic with the same question: Searching Repeating Group with Wildcard
So, partial-word matching is not supported now.

Maybe you could add a field for “tags” or partial words, then search that field. Like the sports thing could have a field for “football” and another field with “foot ball fot foo bal” and so on. That would help catch misspellings too.

This topic was automatically closed after 70 days. New replies are no longer allowed.