Here's what I've ended up doing until I can find another solution. I created a dropdown for the version and set up conditions that I then passed to the panels below with my queries to indicate which one to display. I added two panels at the top that tell the user which version to choose from the Marina Version dropdown. <form version="1.1" theme="light">
<label>Education Title Report</label>
<search>
<query>| inputlookup HealthcareMasterList.csv
| search propertyId=$propertyId$
| table propertyId FullHospitalName MarinaVersion
| join type=left propertyId
[ search sourcetype=sysconfighost-v* earliest=-24@h propertyId=$propertyId$
| dedup propertyId hostId sortby -dateTime
| stats max(coreVersion) as coreVersion by propertyId]
| eval version=if(isnull(coreVersion),MarinaVersion,coreVersion)
| eval version=substr(version,1,2)
| eval version=case(version IN ("6.","10","11","12","14"),"Pre15",version IN ("15","16","17","18"),"Post15",1=1,version)
| fields - MarinaVersion coreVersion</query>
<preview>
<eval token="MarinaVersion">$result.version$</eval>
</preview>
</search>
<fieldset submitButton="true" autoRun="false">
<input type="dropdown" token="propertyId" searchWhenChanged="true">
<label>Site</label>
<fieldForLabel>FullHospitalName</fieldForLabel>
<fieldForValue>propertyId</fieldForValue>
<search>
<query>| inputlookup HealthcareMasterList.csv
| search ITV=1 AND ITV_INSTALLED>1
| table propertyId FullHospitalName MarinaVersion
| join type=left propertyId
[ search sourcetype=sysconfighost-v*
[| inputlookup HealthcareMasterList.csv
| search ITV=1 AND ITV_INSTALLED>1
| fields propertyId
| format]
| dedup propertyId hostId sortby -dateTime
| stats max(coreVersion) as coreVersion by propertyId]
| eval version=if(isnull(coreVersion),MarinaVersion,coreVersion)
| eval version=substr(version,1,2)
| eval version=case(version IN ("6.","10","11","12","14"),"Pre15",version IN ("15","16","17","18"),"Post15",1=1,version)
| fields - MarinaVersion coreVersion
| sort FullHospitalName</query>
<earliest>-24h@h</earliest>
<latest>now</latest>
</search>
</input>
<input type="dropdown" token="WhichVersion">
<label>Marina Version</label>
<choice value="Pre15">Pre15</choice>
<choice value="Post15">Post15</choice>
<choice value="NA">NA</choice>
<change>
<condition value="Post15">
<unset token="NoAssignments"></unset>
<set token="IncludesAssignments">true</set>
<unset token="NoInfo"></unset>
</condition>
<condition value="Pre15">
<set token="NoAssignments">true</set>
<unset token="IncludesAssignments"></unset>
<unset token="NoInfo"></unset>
</condition>
<condition value="NA">
<unset token="NoAssignments"></unset>
<unset token="IncludesAssignments"></unset>
<set token="NoInfo">true</set>
</condition>
</change>
</input>
<input type="time" token="field1" searchWhenChanged="true">
<label>Date Picker</label>
<default>
<earliest>-1mon@mon</earliest>
<latest>@mon</latest>
</default>
</input>
</fieldset>
<row>
<panel>
<html>Please select the following for the Marina Version dropdown:</html>
</panel>
<panel>
<html>$MarinaVersion$</html>
</panel>
</row> Having the user have to use the version dropdown what not what I wanted to do but this at least works for now until stumble upon a better method.
... View more
