topic Re: Create dropdown menu from mutliple sources in Dashboards & Visualizations

How to create dropdown menu from multiple sources?

michael_vi — Tue, 20 Dec 2022 14:38:16 GMT

Hi all,

I need to create 2 drop down fields that depend on each other from several source:

When I choose A, I get only A values. B - only B values and etc.

The queries are coming from several sources, so I can't append or union, I need to create token for each value.

Please assist

Name	Value
A	A values

Re: Create dropdown menu from mutliple sources

ITWhisperer — Tue, 20 Dec 2022 12:22:28 GMT

If I understand correctly, you have two drop downs and you want the selection made in the first to influence the values available in the second?

Set the value for each label in the first to be something that can be used in the construction of the second, e.g. makeresults | eval value = split($firsttoken$, " ") | mvexpand value | eval label = value

Re: Create dropdown menu from mutliple sources

michael_vi — Tue, 20 Dec 2022 13:02:35 GMT

I need to create one drop down for all the sources.

Under input name I'll have A | B | C and each time I choose the name, I'' see the corresponding values in the Value input

query 1
set token = query1

query 2
set token = query2

query 3
set token = query3

And the drop down input will present all 3 name

Re: Create dropdown menu from mutliple sources

ITWhisperer — Tue, 20 Dec 2022 16:24:23 GMT

Can you share the simple XML for your drop downs in a code block </> please?

Re: Create dropdown menu from mutliple sources

michael_vi — Thu, 22 Dec 2022 12:18:47 GMT

<form> <label>dropdown_</label> <search id="base1"> <query>| makeresults | eval name = "Disney" | eval value = mvappend("Mickey Mouse","Donald Duck","Dumbo","Scooby","Olaf") | table name value | stats values(*) as * by name value</query> <sampleRatio>1</sampleRatio> <done> <set token="value_tok">$result.value$</set> </done> </search> <search id="base2"> <query>| makeresults | eval name = "WB" | eval value = mvappend("Pinky","Brain","Daffy Duck","Bugs","Batman") | table name value | stats values(*) as * by name value</query> <sampleRatio>1</sampleRatio> <done> <set token="value_tok">$result.value$</set> </done> </search> <search id="base3"> <query>| makeresults | eval name = "SesameStreet" | eval value = mvappend("Elmo","Bert","Big Bird","Kermit","Ernie") | table name value | stats values(*) as * by name value</query> <sampleRatio>1</sampleRatio> <done> <set token="value_tok">$result.value$</set> </done> </search> <fieldset submitButton="false"> <input type="dropdown" token="name_tok"> <label>Name</label> <choice value="Disney">Disney</choice> <choice value="WB">WB</choice> <choice value="SesameStreet">SesameStreet</choice> <change> <condition value="Disney"> <set token="disney_tok">true</set> <unset token="wb_tok"></unset> <unset token="sesame_tok"></unset> </condition> <condition value="WB"> <unset token="disney_tok"></unset> <set token="wb_tok">true</set> <unset token="sesame_tok"></unset> </condition> <condition value="SesameStreet"> <unset token="disney_tok"></unset> <unset token="wb_tok"></unset> <set token="sesame_tok">true</set> </condition> </change> </input> <input type="dropdown" token="value_tok"> <label>field1</label> <fieldForLabel>value</fieldForLabel> <fieldForValue>value</fieldForValue> <search> <query>| search name = "$name_tok$" | search value = "$value_tok$"</query> <earliest>-24h@h</earliest> <latest>now</latest> </search> </input> </fieldset> <row> <panel depends="$disney_tok$"> <table> <search base="base1"> <query>| table * | search name = "$name_tok$" | search value = "$value_tok$"</query> </search> <option name="count">50</option> <option name="dataOverlayMode">none</option> <option name="drilldown">none</option> <option name="percentagesRow">false</option> <option name="refresh.display">progressbar</option> <option name="rowNumbers">false</option> <option name="totalsRow">false</option> <option name="wrap">true</option> </table> </panel> </row> <row> <panel depends="$wb_tok$"> <table> <search base="base2"> <query>| table * | search name = "$name_tok$" | search value = "$value_tok$"</query> </search> <option name="count">50</option> <option name="dataOverlayMode">none</option> <option name="drilldown">none</option> <option name="percentagesRow">false</option> <option name="refresh.display">progressbar</option> <option name="rowNumbers">false</option> <option name="totalsRow">false</option> <option name="wrap">true</option> </table> </panel> </row> <row> <panel depends="$sesame_tok$"> <table> <search base="base3"> <query>| table * | search name = "$name_tok$" | search value = "$value_tok$"</query> </search> <option name="count">50</option> <option name="dataOverlayMode">none</option> <option name="drilldown">none</option> <option name="percentagesRow">false</option> <option name="refresh.display">progressbar</option> <option name="rowNumbers">false</option> <option name="totalsRow">false</option> <option name="wrap">true</option> </table> </panel> </row> </form>

I need for the second drop down to be connected to first drop down and to each table

Re: Create dropdown menu from mutliple sources

ITWhisperer — Tue, 27 Dec 2022 09:00:33 GMT

Try something like this

<form> <label>dropdown_</label> <search id="base1"> <query>| makeresults | eval name = "Disney" | eval value = mvappend("Mickey Mouse","Donald Duck","Dumbo","Scooby","Olaf") | table name value | stats values(*) as * by name value</query> <sampleRatio>1</sampleRatio> </search> <search id="base2"> <query>| makeresults | eval name = "WB" | eval value = mvappend("Pinky","Brain","Daffy Duck","Bugs","Batman") | table name value | stats values(*) as * by name value</query> <sampleRatio>1</sampleRatio> </search> <search id="base3"> <query>| makeresults | eval name = "SesameStreet" | eval value = mvappend("Elmo","Bert","Big Bird","Kermit","Ernie") | table name value | stats values(*) as * by name value</query> <sampleRatio>1</sampleRatio> </search> <fieldset submitButton="false"> <input type="dropdown" token="name_tok"> <label>Name</label> <choice value="| makeresults | eval name = "Disney" | eval value = mvappend("Mickey Mouse","Donald Duck","Dumbo","Scooby","Olaf") | table name value | stats values(*) as * by name value">Disney</choice> <choice value="| makeresults | eval name = "WB" | eval value = mvappend("Pinky","Brain","Daffy Duck","Bugs","Batman") | table name value | stats values(*) as * by name value">WB</choice> <choice value="| makeresults | eval name = "SesameStreet" | eval value = mvappend("Elmo","Bert","Big Bird","Kermit","Ernie") | table name value | stats values(*) as * by name value">SesameStreet</choice> <change> <condition label="Disney"> <set token="disney_tok">true</set> <unset token="wb_tok"></unset> <unset token="sesame_tok"></unset> <unset token="form.value_tok"></unset> </condition> <condition label="WB"> <unset token="disney_tok"></unset> <set token="wb_tok">true</set> <unset token="sesame_tok"></unset> <unset token="form.value_tok"></unset> </condition> <condition label="SesameStreet"> <unset token="disney_tok"></unset> <unset token="wb_tok"></unset> <set token="sesame_tok">true</set> <unset token="form.value_tok"></unset> </condition> </change> </input> <input type="dropdown" token="value_tok"> <label>field1</label> <fieldForLabel>value</fieldForLabel> <fieldForValue>value</fieldForValue> <search> <query>$name_tok$</query> <earliest>-24h@h</earliest> <latest>now</latest> </search> </input> </fieldset> <row> <panel depends="$disney_tok$"> <table> <search base="base1"> <query></query> </search> <option name="count">50</option> <option name="dataOverlayMode">none</option> <option name="drilldown">none</option> <option name="percentagesRow">false</option> <option name="refresh.display">progressbar</option> <option name="rowNumbers">false</option> <option name="totalsRow">false</option> <option name="wrap">true</option> </table> </panel> </row> <row> <panel depends="$wb_tok$"> <table> <search base="base2"> <query></query> </search> <option name="count">50</option> <option name="dataOverlayMode">none</option> <option name="drilldown">none</option> <option name="percentagesRow">false</option> <option name="refresh.display">progressbar</option> <option name="rowNumbers">false</option> <option name="totalsRow">false</option> <option name="wrap">true</option> </table> </panel> </row> <row> <panel depends="$sesame_tok$"> <table> <search base="base3"> <query></query> </search> <option name="count">50</option> <option name="dataOverlayMode">none</option> <option name="drilldown">none</option> <option name="percentagesRow">false</option> <option name="refresh.display">progressbar</option> <option name="rowNumbers">false</option> <option name="totalsRow">false</option> <option name="wrap">true</option> </table> </panel> </row> </form>

Re: Create dropdown menu from mutliple sources

michael_vi — Mon, 09 Jan 2023 06:50:02 GMT

That will work if you know the values of the "values" column, but I don't.

For example:

| makeresults count=10 | eval name = "Disney" | eval value = "user".random() % 100

Re: Create dropdown menu from mutliple sources

ITWhisperer — Mon, 09 Jan 2023 08:27:28 GMT

What makes you think it won't work?

<form> <label>dropdown_</label> <search id="base1"> <query>| makeresults count=10 | eval name = "Disney" | eval value = "user".random()%10</query> <sampleRatio>1</sampleRatio> </search> <search id="base2"> <query>| makeresults count=10 | eval name = "WB" | eval value = "user".random()%10</query> <sampleRatio>1</sampleRatio> </search> <search id="base3"> <query>| makeresults count=10 | eval name = "SesameStreet" | eval value = "user".random()%10</query> <sampleRatio>1</sampleRatio> </search> <fieldset submitButton="false"> <input type="dropdown" token="name_tok"> <label>Name</label> <choice value="| makeresults count=10 | eval name = "Disney" | eval value = "user".random()%10">Disney</choice> <choice value="| makeresults count=10 | eval name = "WB" | eval value = "user".random()%10">WB</choice> <choice value="| makeresults count=10 | eval name = "SesameStreet" | eval value = "user".random()%10">SesameStreet</choice> <change> <condition label="Disney"> <set token="disney_tok">true</set> <unset token="wb_tok"></unset> <unset token="sesame_tok"></unset> <unset token="form.value_tok"></unset> </condition> <condition label="WB"> <unset token="disney_tok"></unset> <set token="wb_tok">true</set> <unset token="sesame_tok"></unset> <unset token="form.value_tok"></unset> </condition> <condition label="SesameStreet"> <unset token="disney_tok"></unset> <unset token="wb_tok"></unset> <set token="sesame_tok">true</set> <unset token="form.value_tok"></unset> </condition> </change> </input> <input type="dropdown" token="value_tok"> <label>field1</label> <fieldForLabel>value</fieldForLabel> <fieldForValue>value</fieldForValue> <search> <query>$name_tok$</query> <earliest>-24h@h</earliest> <latest>now</latest> </search> </input> </fieldset> <row> <panel depends="$disney_tok$"> <table> <search base="base1"> <query></query> </search> <option name="count">50</option> <option name="dataOverlayMode">none</option> <option name="drilldown">none</option> <option name="percentagesRow">false</option> <option name="refresh.display">progressbar</option> <option name="rowNumbers">false</option> <option name="totalsRow">false</option> <option name="wrap">true</option> </table> </panel> </row> <row> <panel depends="$wb_tok$"> <table> <search base="base2"> <query></query> </search> <option name="count">50</option> <option name="dataOverlayMode">none</option> <option name="drilldown">none</option> <option name="percentagesRow">false</option> <option name="refresh.display">progressbar</option> <option name="rowNumbers">false</option> <option name="totalsRow">false</option> <option name="wrap">true</option> </table> </panel> </row> <row> <panel depends="$sesame_tok$"> <table> <search base="base3"> <query></query> </search> <option name="count">50</option> <option name="dataOverlayMode">none</option> <option name="drilldown">none</option> <option name="percentagesRow">false</option> <option name="refresh.display">progressbar</option> <option name="rowNumbers">false</option> <option name="totalsRow">false</option> <option name="wrap">true</option> </table> </panel> </row> </form>

If you are still experiencing problems, please be more specific about your usecase.