Hi
In my dashboard I use a first dropdown list with static values
These values make reference to the SITE fields I use in my different reports with the lookup below :
| lookup TOTO.csv HOSTNAME as host output SITE
Now, I would be able to update a second dropdown list from the first need
It means that when I select the SITE field in the first drilldown, I would like to display in the second dropdown list all the host corresponding to the SITE selected in the first dropdown list
Could you help me please?
Use the token from first dropdown in the second drop down by using a dynamic search.
Please find a run anywhere example
<form>
<label>Drop Down</label>
<fieldset submitButton="false">
<input type="dropdown" token="site">
<label>Site</label>
<choice value="site1">Site1</choice>
<choice value="site2">Site2</choice>
<choice value="site3">Site3</choice>
<default>site1</default>
<initialValue>site1</initialValue>
</input>
<input type="dropdown" token="host">
<label>Host</label>
<fieldForLabel>hosts</fieldForLabel>
<fieldForValue>hosts</fieldForValue>
<search>
<query>|makeresults|eval site="site1 site1 site2 site2 site3 site3"|makemv site|mvexpand site
|appendcols [|makeresults | eval hosts="host1 host2 host3 host4 host5 host6"|makemv hosts|mvexpand hosts]
|where site="$site$"
|stats count by hosts|fields hosts</query>
<earliest>-15m</earliest>
<latest>now</latest>
</search>
</input>
</fieldset>
<row>
<panel>
<table>
<search>
<query>|makeresults|eval site="site1 site1 site2 site2 site3 site3"|makemv site|mvexpand site
|appendcols [|makeresults | eval hosts="host1 host2 host3 host4 host5 host6"|makemv hosts|mvexpand hosts]
|where site="$site$"</query>
<earliest>-15m</earliest>
<latest>now</latest>
</search>
<option name="drilldown">none</option>
</table>
</panel>
</row>
</form>
Table is just a display of second dropdown search
Use the token from first dropdown in the second drop down by using a dynamic search.
Please find a run anywhere example
<form>
<label>Drop Down</label>
<fieldset submitButton="false">
<input type="dropdown" token="site">
<label>Site</label>
<choice value="site1">Site1</choice>
<choice value="site2">Site2</choice>
<choice value="site3">Site3</choice>
<default>site1</default>
<initialValue>site1</initialValue>
</input>
<input type="dropdown" token="host">
<label>Host</label>
<fieldForLabel>hosts</fieldForLabel>
<fieldForValue>hosts</fieldForValue>
<search>
<query>|makeresults|eval site="site1 site1 site2 site2 site3 site3"|makemv site|mvexpand site
|appendcols [|makeresults | eval hosts="host1 host2 host3 host4 host5 host6"|makemv hosts|mvexpand hosts]
|where site="$site$"
|stats count by hosts|fields hosts</query>
<earliest>-15m</earliest>
<latest>now</latest>
</search>
</input>
</fieldset>
<row>
<panel>
<table>
<search>
<query>|makeresults|eval site="site1 site1 site2 site2 site3 site3"|makemv site|mvexpand site
|appendcols [|makeresults | eval hosts="host1 host2 host3 host4 host5 host6"|makemv hosts|mvexpand hosts]
|where site="$site$"</query>
<earliest>-15m</earliest>
<latest>now</latest>
</search>
<option name="drilldown">none</option>
</table>
</panel>
</row>
</form>
Table is just a display of second dropdown search