Hi All,
I am trying to use a drop-down to run a search based on whats selected currently (in the drop-down) in Dashboard Studio
Here is what I have so far :
What can I do to show data in the form of a table based on the item selected in the drop-down ?
Hi @phwork,
let me understand: you have a lookup containing two columns:
you want to create a dropdown, populated with this lookup, and run the search choosed in the dropdown, is this correct?
Why do you say that "$token$ will not be enough."?
you could run something like this:
<form>
<label>Test</label>
<fieldset submitButton="false">
<input type="dropdown" token="dropdown">
<label>Dropdown</label>
<search>
<query>
| inputlookup command_lookup.csv
| sort search_title
| table search_title search
</query>
<earliest>-24h@h</earliest>
<latest>now</latest>
</search>
<fieldForLabel>search_title</fieldForLabel>
<fieldForValue>search</fieldForValue>
</input>
</fieldset>
<row>
<panel>
<title>Test</title>
<table>
<search>
<query>$dropdown$</query>
<earliest>0</earliest>
<latest></latest>
</search>
<option name="count">30</option>
<option name="drilldown">none</option>
<option name="rowNumbers">true</option>
</table>
</panel>
</row>
</form>
Ciao.
Giuseppe
Hi Giuseppe,
Thank you for your reply.
I have a drop-down with 4 items. Each of the items has a different search associated with it. Based on what is picked in the drop-down, a search needs to run and display data in a a table. Also, this is in Dashboard Studio.
Hi @phwork,
now I'm prefering to wait to use Dashboard Studio until it will have all the features of Dashboard Classic!
Anyway, the approach I hintd is correct and runs on Classic Dashboards, try to apply to Dashboard Studio, it should run in the same way.
Ciao.
Giuseppe