https://community.splunk.com/t5/Dashboards-Visualizations/Error-in-where-command/m-p/513217#M34247 <P><a href="https://community.splunk.com/t5/user/viewprofilepage/user-id/129407">@thambisetty</a>&nbsp; Thank you for the solution</P> Sun, 09 Aug 2020 16:38:05 GMT rkris 2020-08-09T16:38:05Z https://community.splunk.com/t5/Dashboards-Visualizations/Error-in-where-command/m-p/513213#M34245 <P>I get this error when i select the 'All' value from my dropdown input option as shown below</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="splunk_qns5_p1.PNG"><img src="https://community.splunk.com/t5/image/serverpage/image-id/10143iF3846F21195E3555/image-dimensions/390x274?v=v2" alt="splunk_qns5_p1.PNG" title="splunk_qns5_p1.PNG" /></span></P><P>&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="splunk_qns5_p2.PNG"><img src="https://community.splunk.com/t5/image/serverpage/image-id/10144i8692C751067AA72E/image-size/small?v=v2&amp;px=200" alt="splunk_qns5_p2.PNG" title="splunk_qns5_p2.PNG" /></span></P><P>&nbsp;</P><P>These are the static and dynamic options that i've added in my dropdown input&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="splunk_qns5_p3.PNG"><img src="https://community.splunk.com/t5/image/serverpage/image-id/10145iD9DB36CDD1D06E89/image-size/medium?v=v2&amp;px=400" alt="splunk_qns5_p3.PNG" title="splunk_qns5_p3.PNG" /></span></P><P>&nbsp;</P><P>This is the search query i used for the panel where i received the error</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="splunk_qns5_p4.PNG"><img src="https://community.splunk.com/t5/image/serverpage/image-id/10146iB0BB58624F922EA2/image-dimensions/316x106?v=v2" alt="splunk_qns5_p4.PNG" title="splunk_qns5_p4.PNG" /></span></P><P>&nbsp;</P><P>How do I fix this error?</P><P>&nbsp;</P> Sun, 09 Aug 2020 16:14:11 GMT https://community.splunk.com/t5/Dashboards-Visualizations/Error-in-where-command/m-p/513213#M34245 rkris 2020-08-09T16:14:11Z https://community.splunk.com/t5/Dashboards-Visualizations/Error-in-where-command/m-p/513215#M34246 <P>I believe you are matching Target_Account_Name from the dropdown variable $changed$<BR /><BR /></P><P>is ALL in dropdown set to *?</P><P>is that right?</P><P>if yes, replace where with below</P><P>| search Target_Account_Name=*$changed$*</P> Sun, 09 Aug 2020 16:33:03 GMT https://community.splunk.com/t5/Dashboards-Visualizations/Error-in-where-command/m-p/513215#M34246 thambisetty 2020-08-09T16:33:03Z https://community.splunk.com/t5/Dashboards-Visualizations/Error-in-where-command/m-p/513217#M34247 <P><a href="https://community.splunk.com/t5/user/viewprofilepage/user-id/129407">@thambisetty</a>&nbsp; Thank you for the solution</P> Sun, 09 Aug 2020 16:38:05 GMT https://community.splunk.com/t5/Dashboards-Visualizations/Error-in-where-command/m-p/513217#M34247 rkris 2020-08-09T16:38:05Z