Hello,
inside my dashboard I have a multi select input. The options in this field are determined by a query, which is working perfectly fine. I would like to hide or display certain fields if a specific value is inside this result set (I do know the column name but not the position). Please note that the fields should get displayed before anything is selected in the multi value field.
I already have a working solution in case the value I am looking for is returned at the first position in my query using this (for the sake of readability simplified) code:
<input type="multiselect">
<label>Please Select</label>
<search>
<query>"a query returing a table with two column and multiple rows"
</query>
<done>
<set token="QUERY_result">$result.column$</set>
<eval token="QUERY_check">case($QUERY_result$=="theValueIamLookingFor","true")</eval>
</done>
</search>
</input>
<input type="radio" token="RadioTest" depends="$QUERY_check$">
</input>
If the value is returned on another position the solution is not working anymore. Is there a way to loop through the result, somewhat like shown in the below code snipped. Since it is planed to show or hide multiple views based on different values.
for each row in result.column do
if row == "searchString1" do
set token1
done
if row == "searchString2" do
set token2
done
[...]
done
If it is somehow possible without alter the query it would be perfect since it is used on other places in the dashboard and it would get messy to change it.
... View more
