How to search filter advanced trucated on any word of a field

Need help Database
1

Hello.
1 - If I type nothing in the input on the right; the rg display the event that it has to display ! OK

image
image1781×379 53.4 KB

2 - If I type one letter or different letters, the filter is on the first world. OK

image
image927×427 26 KB

3 - But if I type eg: “Trois” in the input, The RG return nothing.

image
image996×294 17.5 KB

How to do the search/ filtered on any word or start of a word of the input…

Currently my filter is

image

Thanks

3

I would want to play around with this one, but at a glance, what is the purpose of using :truncated to? Couldn’t the filter just be This Event's Event_Name contains Input Search's value?

Best…
Mike

4

I’ve done it whith this link :wink:

5

Today I learned contains doesn’t do exactly what I thought it did. :slight_smile:

Thanks for providing the link… very interesting. I have to be honest, though, and say I still don’t fully understand the use of :truncated to here. In your example of searching for “Trois”, the event name gets truncated to the number of characters in the search (in this case, five characters), so it is searching “Les T” for a value of “Trois”. Am I at least understanding that correctly? At this point, I am more curious than anything, so feel free to ignore this response if you wish.

Best…
Mike