topic Re: Dynamic dropdown field options using another dropdown value in Dashboards & Visualizations

Dynamic dropdown field options using another dropdown value

ISP8055 — Wed, 24 Feb 2021 18:01:44 GMT

Hi there,
Is there a way to create/display a dynamic dropdown using value selected from another dropdown?

For example of what I'm trying to do:
Suppose I have 2 fields: Region and Server Name.

Region Server

NY A1

B1
X1

LA A2

TO A3

So, the first drop-down gives the user option of selecting region : TO, NY or LA.
User selects the region: NY,

then it should display a dropdown listing the name of NY's server names

and when the user selects a NY server: B1, then it displays the panel based on search for server: S1

Re: Dynamic dropdown field options using another dropdown value

manjunathmeti — Wed, 24 Feb 2021 18:15:17 GMT

hi @ISP8055,

Yes, you can use the first dropdown token in the second dropdown to filter results. Check this.

<fieldset submitButton="true" autoRun="false"> <input type="dropdown" token="sourcetype"> <label>Sourcetype</label> <fieldForLabel>sourcetype</fieldForLabel> <fieldForValue>sourcetype</fieldForValue> <search> <query>index=_internal | stats count by sourcetype</query> <earliest>-60m@m</earliest> <latest>now</latest> </search> </input> <input type="dropdown" token="host"> <label>Hosts</label> <fieldForLabel>host</fieldForLabel> <fieldForValue>host</fieldForValue> <search> <query>index=_internal sourcetype="$sourcetype$" | stats count by host</query> <earliest>-24h@h</earliest> <latest>now</latest> </search> </input> </fieldset>

If this reply helps you, an upvote/like would be appreciated.

Re: Dynamic dropdown field options using another dropdown value

ISP8055 — Wed, 24 Feb 2021 20:57:03 GMT

Hi there,

I tried your search syntax. However, when I select a option from the first dropdown list, the second dropdown doesn't let me select. Second dropdown is greyed out.

Re: Dynamic dropdown field options using another dropdown value

ISP8055 — Thu, 25 Feb 2021 02:39:54 GMT

Hi,

I did further troubleshooting and found the issue with my search query. Your syntax helped.
Thanks.