Thanks In Advance. I am using dropdown values for my requirement. In the dropdown i am using token and getting the values from inputlookup and i will pass the value to splunk query.There are two dro...
See more...
Thanks In Advance. I am using dropdown values for my requirement. In the dropdown i am using token and getting the values from inputlookup and i will pass the value to splunk query.There are two dropdown one is application Name another one interface name.If i select values i am getting result .If select ALL and the values shows *.in the splunk query.Instead of * .I want to gey values like OR conditions.If i the token getting * then it showing all the values.But i want to show the values which is comming from inputlookup values both application name and interface name. When i am selecting ALL my splunk query like this:
index=mulesoft environment=PRD (applicationName="*" OR priority IN ("ERROR", "WARN"))
| stats values(*) AS * BY correlationId applicationName
| rename content.InterfaceName AS InterfaceName
content.FileList{} AS FileList
content.Filename as FileName
content.ErrorMsg as ErrorMsg
| eval Status=case(priority="ERROR","ERROR", priority="WARN","WARN", priority!="ERROR","SUCCESS")
| fields Status InterfaceName applicationName FileList FileName correlationId ErrorMsg message
| search InterfaceName="*" FileList="*"
| sort -timestamp | sort -timestamp
I am expecting :
index=mulesoft environment=PRD applicationName IN ("Test1" OR "TEST2" OR "Test3") OR priority IN ("ERROR", "WARN")
| stats values(*) AS * BY correlationId applicationName
| rename content.InterfaceName AS InterfaceName
content.FileList{} AS FileList
content.Filename as FileName
content.ErrorMsg as ErrorMsg
| eval Status=case(priority="ERROR","ERROR", priority="WARN","WARN", priority!="ERROR","SUCCESS")
| fields Status InterfaceName applicationName FileList FileName correlationId ErrorMsg message
| search InterfaceName IN ("aa" OR "bb" OR "cc") AND FileList="*"
| sort -timestamp | sort -timestamp
DropDown Code
</input><input type="dropdown" token="BankApp" searchWhenChanged="true" depends="$BankDropDown$">
<label>ApplicationName</label>
<choice value="*">All</choice>
<search>
<query>
| inputlookup BankIntegration.csv
| dedup applicationName
| sort applicationName
| table applicationName
</query>
</search>
<fieldForLabel>applicationName</fieldForLabel>
<fieldForValue>applicationName</fieldForValue>
<default>*</default>
<prefix>applicationName="</prefix>
<suffix>"</suffix>
</input>
<input type="dropdown" token="interface" searchWhenChanged="true" depends="$BankDropDown$">
<label>InterfaceName</label>
<choice value="*">All</choice>
<search>
<query>
| inputlookup BankIntegration.csv
| search $BankApp$
| sort InterfaceName
| table InterfaceName
</query>
</search>
<fieldForLabel>InterfaceName</fieldForLabel>
<fieldForValue>InterfaceName</fieldForValue>
<default>*</default>
<prefix>InterfaceName="</prefix>
<suffix>"</suffix>
</input>