Here first drop down Dates will display last 7 days of date. When user select any one date, query will be executed and that date will be used in query. Results of that query will be displayed in second query. I have tried below mentioned code but it's not throwing any error but my second drop down doesn't populate with correct values. Any pointers you provide will be helpful. Thanks. <input type="dropdown" token="Dates" searchWhenChanged="true">
<label>Date</label>
<fieldForLabel>Dates</fieldForLabel>
<fieldForValue>Dates</fieldForValue>
<search>
<query>| gentimes start=-6 end=+1
| eval Dates=strftime(starttime,"%Y-%m-%d")
| table Dates
</query>
<earliest>-15m</earliest>
<latest>now</latest>
</search>
<default>2020-06-15</default>
<initialValue>2020-06-15</initialValue>
<change>
<set token="form.name">
<search>
<query>index= test|rename body.recordTotals{}.from.* as from*|rename header.eventCode as eventCode|where eventCode = "abc" and fromfromUs="true" and messagingCalendarDate="$Dates$"|stats
count by fromendPointName|table fromendPointName
</query>
<search>
</set>
</change>
</input>
<input type="dropdown" token="name" searchWhenChanged="true">
<label>Name</label>
<fieldForLabel>name</fieldForLabel>
<fieldForValue>name</fieldForValue>
<choice value="All">All</choice>
<default>All</default>
<initialValue>All</initialValue>
</input>
... View more
