I created a drop-down that lists the METRO_CITY name. When selected, it will return multiple router name prefixes to get all routers in that city. How would I pipe all these router names that were returned into a token to be used in another dbquery in the following table?
<input type="dropdown" token="METRO_CITY" searchWhenChanged="true">
<label>Select a location:</label>
<choice value="London">london</choice>
<search>
<query>| dbquery "ROUTERDB" "SELECT METRO_CITY FROM LKP_LOCATION_EDITED" | dedup METRO_CITY</query>
</search>
<default value="Miami (FL)">Miami</default>
<fieldForLabel>METRO_CITY</fieldForLabel>
<fieldForValue>METRO_CITY</fieldForValue>
<change>
<condition value="$METRO_CITY$">
<set token="search_area">
<search>
<query>
| dbquery "ROUTERDB" "SELECT DEVICE_PREFIX FROM LKP_LOCATION_EDITED WHERE METRO_CITY LIKE '%$METRO_CITY$%'"
</query>
</search>
</set>
</condition>
</change>
</input>
<table id="highlight">
<title>GWR</title>
<search>
<query>| dbquery ROUTERDB "select * from tbl_sample_stats WHERE ROUTER LIKE '%$search_area$%' " | table ROUTER </query>
</search>
... View more