Multi select dependable drop down doesn't show value?

[Neel88]

Hi,

I have created multi select dropdown and when I tried to be dependable by passing dropdown token, it doesn't shows any value.

<form>
<label>TEST- Multi Select with distinct value</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_Data" | search adt="$adt$"</query>
<earliest>0</earliest>
<latest></latest>
</search>
<prefix>IN(</prefix>
<suffix>)</suffix>
<valuePrefix>"</valuePrefix>
<valueSuffix>"</valueSuffix>
</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_Data" | search flow="$flow$"</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_Data"
| 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>

[yeahnah]

Hi @Neel88 

Your search query syntax is wrong with the where clause

| where FLOW IN("*") and adt IN("*")

 The where command is for eval-expressions with a boolean result (true or false).  Use search instead of where in the search panel query. The ,optional, and must be in uppercase too, like this

| ...
| search FLOW IN("*") AND adt IN("*")
|...

 Hope this helps