topic Populate dropdown based on previous dropdown value in Dashboards & Visualizations

Populate dropdown based on previous dropdown value

k_harini — Tue, 24 Jan 2017 09:14:08 GMT

I'm able to populate dropdown based on previous dropdown value with passing that token. But when ALL is selected in previous dropdown , i want "ALL" to appear in dependent dropdown without any values. Only when some value is selected, other dropdown should refresh accordingly.

How to achieve that.. ?

Re: Populate dropdown based on previous dropdown value

gcusello — Tue, 24 Jan 2017 09:40:15 GMT

Hi k_harini,
I don't know how is written your dropdown, but I think that in the first one you have ALL ("") as default value and you pass the choosen value (a single value or "") to the second one.
In the second dashboard, I think that you use the first dropdown choice as a filter in the search (e.g.: mysearch $token$), and you have ALL ("*") as default value.
In this way, if you have ALL in the first dropdown, you have ALL also in the second one, if instead you choose a value in the first dropdawn, you have in the second one the possibility to choose both ALL or a single value.
In other word something like this:

<input type="dropdown" token="My1" searchWhenChanged="true">
  <choice value="*">All</choice>
  <search>
    <query>tag=mytag | dedup SS | table My1 | sort My1 </query>
    <earliest>$Time.earliest$</earliest>
    <latest>$Time.latest$</latest>
  </search>
  <fieldForLabel>My1</fieldForLabel>
  <fieldForValue>My1</fieldForValue>
  <default>*</default>
  <prefix>My1="</prefix>
  <suffix>"</suffix>
</input>
<input type="dropdown" token="My2" searchWhenChanged="true">
  <choice value="*">All</choice>
  <search>
    <query>tag=mytag $My1$| dedup My2 | table My2 | sort My2</query>
    <earliest>$Time.earliest$</earliest>
    <latest>$Time.latest$</latest>
  </search>
  <fieldForLabel>My2</fieldForLabel>
  <fieldForValue>My2</fieldForValue>
  <default>*</default>
  <prefix>My2="</prefix>
  <suffix>"</suffix>
</input>

Bye.
Giuseppe

Re: Populate dropdown based on previous dropdown value

k_harini — Tue, 24 Jan 2017 11:17:04 GMT

Thank you so much for your response and the code. I tried this.. Even then All values are getting populated wen i select 'All' in first drop down.. I just want to display 'All' and user should not have the ability to select other values from second drop down.