topic Re: How to change search based on Dropdown? in Dashboards & Visualizations

How to change search based on Dropdown?

phwork — Mon, 13 Jun 2022 20:52:35 GMT

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 :

A drop-down that's populated by an input lookup table.
There are 4 distinct searches.
Every time an item is selected in the drop-down the associated search needs to run and the data displayed needs to change.
The searches are very different from one another so passing a value in a $token$ will not be enough.

What can I do to show data in the form of a table based on the item selected in the drop-down ?

Re: How to change search based on Dropdown?

gcusello — Tue, 14 Jun 2022 06:39:53 GMT

Hi @phwork,

let me understand: you have a lookup containing two columns:

search_title
search_code

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

Re: How to change search based on Dropdown?

phwork — Tue, 14 Jun 2022 12:27:47 GMT

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.

Re: How to change search based on Dropdown?

gcusello — Tue, 14 Jun 2022 12:32:23 GMT

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