We created a dynamic drop down for service code and time range. We have many service code values out of which "null" is one of them. So when we select a particular time range if null value logs are not present also it is showing up in the drop down, We want to see the options in the drop down only if that logs are present during that time.
Below is the xml code used:
<form version="1.1" theme="light">
<label>Dashboard</label>
<fieldset submitButton="false">
<input type="time" token="timepicker">
<label>TimeRange</label>
<default>
<earliest>-15m@m</earliest>
<latest>now</latest>
</default>
</input>
<input type="dropdown" token="ServiceCode">
<label>ServCode</label>
<choice value="*">All</choice>
<default>*</default>
<fieldForLabel>ServiceCode</fieldForLabel>
<fieldForValue>ServiceCode</fieldForValue>
<search>
<query> index=app-index |rename "resource.attributes.servicecode" as ServiceCode
|stats count by ServiceCode
|fields ServiceCode </query>
<earliest>timepicker.earliest</earliest>
<latest>timepicker.latest</latest>
</search>
</input>
</fieldset>
<row>
<panel>
<table>
<title>Incoming Count</title>
<search>
<query>index=app-index source=application.logs AND resource.attributes.servicecode="$ServiceCode$"
|table Income Rej_app ATM DMM Reject Rej_log Rej_app
</query>
<earliest>timepicker.earliest</earliest>
<latest>timepicker.latest</latest>
<sampleRatio>1</sampleRatio>
</search>
<option name="count">20</option>
<option name="dataOverlayMode">none</option>
<option name="drilldown">none</option>
<option name="percentageRow">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>
