Hello,
I am using 2 multi select dropdown. When its on the default value 'ALL' then it doesn't show any value in the table, after selection it works.
After open in search, it shows "*" in the value.
| loadjob savedsearch="TEST"
| where FLOW IN("*") and adt IN("*")
| table adt, FLOW, Date
| fields Date, adt, FLOW, CMTotal
------------------------------------------------------------------
Original Query-
<form>
<label>AAA_Test</label>
<fieldset submitButton="false">
<input type="multiselect" token="flow">
<label>Select Flow</label>
<choice value="*">All</choice>
<default>*</default>
<delimiter>,</delimiter>
<fieldForLabel>FLOW</fieldForLabel>
<fieldForValue>FLOW</fieldForValue>
<search>
<query>| loadjob savedsearch="TEST" | dedup FLOW</query>
<earliest>0</earliest>
<latest></latest>
</search>
<prefix>IN(</prefix>
<suffix>)</suffix>
<valuePrefix>"</valuePrefix>
<valueSuffix>"</valueSuffix>
<initialValue>*</initialValue>
</input>
<input type="multiselect" token="adt">
<label>Select ADT</label>
<choice value="*">All</choice>
<default>*</default>
<delimiter>,</delimiter>
<fieldForLabel>adt</fieldForLabel>
<fieldForValue>adt</fieldForValue>
<search>
<query>| loadjob savedsearch="TEST" | dedup adt</query>
<earliest>0</earliest>
<latest></latest>
</search>
<prefix>IN(</prefix>
<suffix>)</suffix>
<valuePrefix>"</valuePrefix>
<valueSuffix>"</valueSuffix>
<initialValue>*</initialValue>
</input>
</fieldset>
<row>
<panel>
<table>
<search>
<query>| loadjob savedsearch="TEST"
| where FLOW $flow$ and adt $adt$
| table adt, FLOW, Date, NbRecordsOKFCR, CMTotal, NbRecordsOKCM, NBIntFile, NB1, NB2, NB3, NbErrorsCM, Alert
| fields Date, adt, FLOW, CMTotal</query>
<earliest>0</earliest>
<latest></latest>
</search>
<option name="count">10</option>
<option name="drilldown">none</option>
<option name="refresh.display">progressbar</option>
</table>
</panel>
</row>
</form>
Please suggest.
