Visible Binding - Using Expression type binding to search for key word in string

paulm1 · August 5, 2020, 9:39pm

I have a drop down that is populated the following query.

SELECT '%' AS Value,"Select Container"
UNION
Select CONCAT_WS(' ', style, type) AS Value, CONCAT_WS(' ', style, type) AS Label
FROM container
ORDER BY Value ASC

Based on the operators selection of this dropdown I would like to Make Visible( or invisible) other objects on the screen. By looking for key words, in this case the word Can or Bottle.
If it was a query I would search for ‘%Can%’.
What is the best way to accomplish this goal?

witman · August 5, 2020, 9:46pm

This should work as your visibility expression (no match = -1):

indexOf({Dropdown.selectedValue}, "Can") > -1

paulm1 · August 5, 2020, 9:54pm

The Drop down Selection I made is 12oz Standard Can
The Visible Binding is

indexOf({Root Container. Dropdown.selectedValue}, "Can") > -1

Nothing became visible and no errors.

witman · August 5, 2020, 9:56pm

Yeah, selectedValue should be selectedLabel or selectedStringValue–I’m guessing the former (or looking closer at your query, I expect either one will give the same result).

paulm1 · August 5, 2020, 9:59pm

Perfect. Thank you.
Here is what appears to be working.