How to filter a Repeater-Field that contains specific String?

[mbc66]

@AAlainn

how can I filter a Repeater-Field that contains specific String?

Here is a forum thread with a solution:

Searching a string

If a repeater data-cell contains a string, then that string will have an index within the repeater cell data. What you need to use is ‘.indexOf()’ Set your rule as [[LVAR1.indexOf(LVAR2) >= ‘0’]] Where LVAR1 is the data you are interrogating and LVAR2 is the string you’re looking for.

Applying this expression to a Repeater, where you have a column labeled, “City” would look like:
[[ Item.City.indexOf(LVAR1) >= 0 ]]

• Where LVAR1 is your filter or “search” string.
• The .indexOf() function will return a number which is the index of the first character in the search string. If the search string is not found in the target string, it returns -1, thus the rule would fail.
• Note this works for any string (portion) regardless of position. So in your example above, filtering for “n” would result in all three items shown; filtering for “or” would also result in all three items shown.
• (numbers in logical expressions don’t need quotes; works either way with 0 or ‘0’)

Applying this to a Text Field for “live dynamic filtering”, you can use this widget’s Text Changed or Key Up event (fired every time a keyboard key is pressed and released)–and using “case insensitive” logic–the filter rule would be:
[[ Item.City.toLowerCase().indexOf(This.text.toLowerCase()) >= 0 ]]

Here is a little demo:
Live Dynamic Filter.rp (55.3 KB)