Hello Everyone,
I am stuck with a dropdown issue, my requirement is whenever user select different value in previous dropdowns the next dropdown value should unset/clear/set to All(default value).
I have 9 dropdowns, dropdown first to forth are working fine but fifth, sixth and seventh dropdowns are not unsetting the value when user select previous dropdowns.
Could someone please help.....
<fieldset submitButton="false">
<input type="dropdown" token="token1" searchWhenChanged="true">
<label>PSL</label>
<fieldForLabel>First</fieldForLabel>
<fieldForValue>First</fieldForValue>
<change>
<set token="token1">$value$</set>
<unset token="form.token6"></unset>
<unset token="form.token2"></unset>
<unset token="form.token3"></unset>
<unset token="form.token4"></unset>
<unset token="form.token5"></unset>
<unset token="form.token7"></unset>
</change>
<search>
<query>| inputlookup Filters_Data_PLM2B05.csv
| table First
| dedup First</query>
<earliest>-24h@h</earliest>
<latest>now</latest>
</search>
<default>DPP</default>
<initialValue>DPP</initialValue>
</input>
<input type="dropdown" token="token2" searchWhenChanged="true">
<label>second</label>
<default>$form.token_from_another_dashboard1$</default>
<initialValue>$form.token_from_another_dashboard1$</initialValue>
<fieldForLabel>portfolio</fieldForLabel>
<fieldForValue>portfolio</fieldForValue>
<selectFirstChoice>true</selectFirstChoice>
<change>
<set token="token2">$value$</set>
<unset token="form.token6"></unset>
<unset token="form.token3"></unset>
<unset token="form.token4"></unset>
<unset token="form.token5"></unset>
<unset token="form.token7"></unset>
</change>
<search>
<cancelled>
<unset token="form.token_from_another_dashboard1"></unset>
</cancelled>
<query>| inputlookup Filters_Data_PLM2B05.csv
| search First=$token1$
| table portfolio
| dedup portfolio
| sort portfolio</query>
<earliest>-4h@h</earliest>
<latest>now</latest>
</search>
</input>
<input type="dropdown" token="token3" searchWhenChanged="true">
<label>Third</label>
<default>$form.token_from_another_dashboard2$</default>
<initialValue>$form.token_from_another_dashboard2$</initialValue>
<fieldForLabel>application_name</fieldForLabel>
<fieldForValue>token3</fieldForValue>
<change>
<set token="token3">$value$</set>
<unset token="form.token6"></unset>
<unset token="form.token4"></unset>
<unset token="form.token5"></unset>
<unset token="form.token7"></unset>
</change>
<search>
<query>| inputlookup Filters_Data_PLM2B05.csv |search portfolio="$token2$" CONTROL_M="Yes"|eval application_name=token3."-".application_name
|table application_name token3 |sort token3</query>
<earliest>-4h@h</earliest>
<latest>now</latest>
<cancelled>
<unset token="form.token_from_another_dashboard2"></unset>
<unset token="form.token3"></unset>
</cancelled>
</search>
</input>
<input type="dropdown" token="token4" searchWhenChanged="true">
<label>Job Name</label>
<fieldForLabel>Forth</fieldForLabel>
<fieldForValue>Forth</fieldForValue>
<change>
<set token="token4">$value$</set>
<unset token="form.token6"></unset>
<unset token="form.token5"></unset>
<unset token="form.token7"></unset>
</change>
<search base="basesearch">
<query>|stats values(Forth) as Forth
|mvexpand Forth</query>
</search>
<choice value="*">All</choice>
<default>*</default>
<initialValue>*</initialValue>
</input>
<input type="dropdown" token="token5" searchWhenChanged="true">
<label>Fifth</label>
<fieldForLabel>token5</fieldForLabel>
<fieldForValue>token5</fieldForValue>
<change>
<set token="token5">$value$</set>
<unset token="form.token6"></unset>
<unset token="form.token7"></unset>
</change>
<search base="basesearch">
<query>|stats values(token5) as token5
|mvexpand token5</query>
</search>
<choice value="*">All</choice>
<default>*</default>
<initialValue>*</initialValue>
</input>
<input type="dropdown" token="token6" searchWhenChanged="true">
<label>sixth</label>
<fieldForLabel>job_frequency</fieldForLabel>
<fieldForValue>job_frequency</fieldForValue>
<change>
<set token="token6">$value$</set>
<unset token="form.token7"></unset>
</change>
<search base="basesearch">
<query>|stats values(job_frequency) as job_frequency
|mvexpand job_frequency</query>
</search>
<choice value="*">All</choice>
<default>*</default>
<initialValue>*</initialValue>
</input>
<input type="dropdown" token="token7" searchWhenChanged="true">
<label>seventh</label>
<fieldForLabel>token7</fieldForLabel>
<fieldForValue>token7</fieldForValue>
<change>
<set token="token7">$value$</set>
</change>
<search base="basesearch">
<query>|stats values(token7) as token7
|mvexpand token7</query>
</search>
<choice value="*">All</choice>
<default>*</default>
<initialValue>*</initialValue>
</input>
<input type="dropdown" token="timepicker_token" searchWhenChanged="true">
<label>Time Picker</label>
<choice value="Today">Today</choice>
<choice value="week_to_date">Week to date</choice>
<choice value="business_week_to_date">Business Week to date</choice>
<choice value="month_to_date">Month to date</choice>
<choice value="year_to_date">Year to date</choice>
<choice value="Yesterday">Yesterday</choice>
<choice value="Previous_week">Previous week</choice>
<choice value="Previous_business_week">Previous business week</choice>
<choice value="Previous_month">Previous month</choice>
<choice value="Previous_two_month">Previous two month</choice>
<choice value="Previous_year">Previous year</choice>
<choice value="Last_60_mins">Last 60 minutes</choice>
<choice value="Last_4_hours">Last 4 hours</choice>
<choice value="Last_7_days">Last 7 days</choice>
<choice value="Last_30_days">Last 30 days</choice>
<choice value="Last_3_months">Last 3 months</choice>
<choice value="Last_6_months">Last 6 months</choice>
<choice value="Last_9_months">Last 9 months</choice>
<choice value="Last_1_year">Last 1 year</choice>
<change>
<condition value="Last_60_mins">
<set token="earliest_time">-60m@m</set>
<set token="latest_time">@s</set>
</condition>
<condition value="Last_4_hours">
<set token="earliest_time">-4h@m</set>
<set token="latest_time">@s</set>
</condition>
<condition value="Today">
<set token="earliest_time">@d</set>
<set token="latest_time">@s</set>
</condition>
<condition value="week_to_date">
<set token="earliest_time">@w0</set>
<set token="latest_time">now</set>
</condition>
<condition value="business_week_to_date">
<set token="earliest_time">@w1</set>
<set token="latest_time">now</set>
</condition>
<condition value="month_to_date">
<set token="earliest_time">@mon</set>
<set token="latest_time">now</set>
</condition>
<condition value="year_to_date">
<set token="earliest_time">@y</set>
<set token="latest_time">now</set>
</condition>
<condition value="Yesterday">
<set token="earliest_time">-1d@d</set>
<set token="latest_time">@d</set>
</condition>
<condition value="Last_7_days">
<set token="earliest_time">-7d@h</set>
<set token="latest_time">-1s@</set>
</condition>
<condition value="Last_30_days">
<set token="earliest_time">-31d@d</set>
<set token="latest_time">-1s@</set>
</condition>
<condition value="Last_3_months">
<set token="earliest_time">-93d@d</set>
<set token="latest_time">-1s@</set>
</condition>
<condition value="Last_6_months">
<set token="earliest_time">-182d@d</set>
<set token="latest_time">-1s@</set>
</condition>
<condition value="Last_9_months">
<set token="earliest_time">-274d@d</set>
<set token="latest_time">-1s@</set>
</condition>
<condition value="Last_1_year">
<set token="earliest_time">-1y@d</set>
<set token="latest_time">-1s@</set>
</condition>
<condition value="Previous_week">
<set token="earliest_time">-7d@w0</set>
<set token="latest_time">@w0</set>
</condition>
<condition value="Previous_business_week">
<set token="earliest_time">-6d@w1</set>
<set token="latest_time">-1d@w6</set>
</condition>
<condition value="Previous_month">
<set token="earliest_time">-1mon@mon</set>
<set token="latest_time">@mon</set>
</condition>
<condition value="Previous_two_month">
<set token="earliest_time">-2mon@mon</set>
<set token="latest_time">@mon</set>
</condition>
<condition value="Previous_year">
<set token="earliest_time">-1y@y</set>
<set token="latest_time">@y</set>
</condition>
</change>
<initialValue>Last_4_hours</initialValue>
<default>Last_4_hours</default>
</input>
<input type="text" token="desc_token" searchWhenChanged="true">
<label>Description search</label>
<default>*</default>
<initialValue>*</initialValue>
</input>
</fieldset>