I have multiple apps in our environment each app represents ApplicationDomain, and all of them have lots of dashboards , where we are using a lookup table values to populate the ApplicationDomain values in the Drop-down. A few ApplicationDomain Names have a space in between the name. where my dashboard global token $emnv:arpp$
AppName : PGR - External Data
AppFoldername is : ExternalData
<form> <label>RRD Restarts Clone__test</label> <fieldset autoRun="false" submitButton="true"> <input type="dropdown" token="domain"> <label>Application Domain</label> <search> <query>|inputlookup ApplicationDomain.csv|stats count by ApplicationDomain |sort +ApplicationDomain</query> <earliest>-24h@h</earliest> <latest>now</latest> </search> <fieldForValue>ApplicationDomain</fieldForValue> **<choice value="$env:anpp$">default</choice>** </input>
How can i work this code for the ApplicationDomain name has space?
value parameter should have exact same values as it appear in lookup table. The global token will give you folder name, not the display name. The lookup also seem to have additional prefix. Where and how is your
domain token is being used?
am using this Application Domain in my entire Dashboard searches
how can i use this i dont know how we can use this to get the app name may app are looking like
BEP:Application Name and in my lookup table Application Domain was like
Application Name and app dir name was ApplicationName
Try this for your dropdown
<input type="dropdown" token="domain"> <label>Application Domain</label> <search> <query>|inputlookup ApplicationDomain.csv|stats count by ApplicationDomain | eval rank=if(match(replace(ApplicationDomain," ",""),"$env:app$"),1,0)|sort -rank +ApplicationDomain | fields - rank</query> <earliest>-24h@h</earliest> <latest>now</latest> </search> <fieldForValue>ApplicationDomain</fieldForValue> <selectFirstChoice>true</selectFirstChoice> </input>
Basically comparing the global token value with ApplicationDomain field with space removed (just for comparision, original value unchanged) and whever matched with place in first place in the dropdown (sort logic using rank). Then configuring dropdown to select the first value by default using
its sorting by rank but still the default value not displaying with space.
my original lookup file and application Domain value indexed with space.