I've a multiselect.
<label>Grade</label>
<default>9,6,7</default>
<fieldForLabel>grade_name</fieldForLabel>
<fieldForValue>grade_name</fieldForValue>
<search>
<query/>
</search>
...
See more...
I've a multiselect.
<label>Grade</label>
<default>9,6,7</default>
<fieldForLabel>grade_name</fieldForLabel>
<fieldForValue>grade_name</fieldForValue>
<search>
<query/>
</search>
<initialValue>9,6,7</initialValue>
</input>
I want to pass these selected values in a where clause:
]
|inputlookup prod_students.csv | table school_name, school_id,grade_name |eventstats max(grade_name) as mx min(grade_name) as mn by school_name,school_id| where grade_name IN ("$grade_name$")
The above query is not working. I can't move the where next to lookup as I'm doing it on the eventstats field.