topic help on issue with a savedsearch and a token from a dropdown list in Dashboards & Visualizations

help on issue with a savedsearch and a token from a dropdown list

jip31 — Wed, 24 Jul 2019 07:31:50 GMT

Hello

I use the code below in all my dashboard searches in order to filter results by SITE from a dropdown list and it works perfectly

| lookup lookup_cmdb_fo_all.csv HOSTNAME as host output SITE 
| search SITE=$tok_filtersite|s$

But I need to use savedsearches in my dashboard
So I call a search from my dshboard like this

| loadjob savedsearch="admin:SA_xxxx_xx_xx_xx_xx_sh:Hardware - Battery last 10"   
| search SITE=$tok_filtersite|s$

And I keep | lookup lookup_cmdb_fo_all.csv HOSTNAME as host output SITE in the search
But I have no results only when I delete | search SITE=$tok_filtersite|s$ ...
So there is an issue with this token in the savedsearches
What I have to do please??

Re: help on issue with a savedsearch and a token from a dropdown list

vnravikumar — Wed, 24 Jul 2019 08:04:20 GMT

Are you getting SITE info after executing savedsearch

Re: help on issue with a savedsearch and a token from a dropdown list

jip31 — Wed, 24 Jul 2019 08:23:57 GMT

hi
I dont understand what you mean
what I need is to :
1) execute my search in a savedsearch
2) filter the data by SITE from the dropdown list in the dashboard (tok_filtersite)

Re: help on issue with a savedsearch and a token from a dropdown list

jip31 — Wed, 24 Jul 2019 08:49:27 GMT

if i am doing this I have no results so I ont get the SITE
| loadjob savedsearch="admin:xxxxx:Hardware - Battery last 10"
| search SITE=*

Re: help on issue with a savedsearch and a token from a dropdown list

vnravikumar — Wed, 24 Jul 2019 09:03:15 GMT

Please confirm whether are you getting values after executing this statement | loadjob savedsearch="admin:xxxxx:Hardware - Battery last 10" without | search SITE=* if yes, SITE info is there?

Re: help on issue with a savedsearch and a token from a dropdown list

jip31 — Wed, 30 Sep 2020 01:29:41 GMT

oh I think I have found
its because in the search I rename SITE by Site
so | search SITE=$tok_filtersite|s$ has to be replaced by | search Site=$tok_filtersite|s$

Re: help on issue with a savedsearch and a token from a dropdown list

vnravikumar — Wed, 24 Jul 2019 09:07:11 GMT

Whether it's working now?

Re: help on issue with a savedsearch and a token from a dropdown list

jip31 — Wed, 24 Jul 2019 09:13:20 GMT

Yes
if I do | loadjob savedsearch="admin:xxxxx:Hardware - Battery last 10"
| search Site=* it works

Re: help on issue with a savedsearch and a token from a dropdown list

vnravikumar — Wed, 24 Jul 2019 09:15:08 GMT

Good to know

Re: help on issue with a savedsearch and a token from a dropdown list

vnravikumar — Wed, 24 Jul 2019 09:17:14 GMT

Please accept to close the issue.