topic Re: Select Multiselect value from URL Token in Dashboards & Visualizations

Select Multiselect value from URL Token

AKG1_old1 — Mon, 19 Apr 2021 15:24:48 GMT

Hi,
I am using a multi-select input in the dashboard, which displays a list of machines. I am looking to access this dashboard with URL having multiple machine comma separated.
My requirement is when I open the link it should have all the machines mentioned in the URL in the multi-select filter

example ( "," replaced with %2C in url)
http://<URL>?host_token=xxx&form.time_token.earliest=1618437600&form.time_token.latest=1618610400&form.MACHINE_TOKEN=hp707srv%2Cdell970srv%2Cdell429srv%2Cdell477srv%2Cdell432srv

Re: Select Multiselect value from URL Token

manjunathmeti — Mon, 19 Apr 2021 19:07:07 GMT

hi @AKG1_old1,

Instead of comma-separated values, you should pass key-value pairs separated by & in the URL endpoint to put values in multi-select input like below assuming MACHINE_TOKEN is the token name of multi-select input.

http://<url>/?host_token=xxx&form.time_token.earliest=1618437600&form.time_token.latest=1618610400&form.MACHINE_TOKEN=hp707srv&form.MACHINE_TOKEN=dell970srv&form.MACHINE_TOKEN=dell429srv&form.MACHINE_TOKEN=dell477srv&form.MACHINE_TOKEN=dell432srv

If this reply helps you, a like would be appreciated.

Select Multiselect value from URL Token

ITWhisperer — Mon, 19 Apr 2021 19:43:52 GMT

If you want a multiselect in the called dashboard to be prepopulated with the values selected in the starting dashboard, I think you can just repeat the variable on the URL

Re: Select Multiselect value from URL Token

ITWhisperer — Mon, 19 Apr 2021 21:17:57 GMT

This might help (assuming you are trying to pass multi-values to another dashboard)

https://community.splunk.com/t5/Splunk-Search/How-to-pass-multiselect-token-values-from-main-dashboard-A-to/m-p/520177/highlight/true#M146478

Re: Select Multiselect value from URL Token

AKG1_old1 — Mon, 19 Apr 2021 21:42:52 GMT

Thanks, Manually its working but there is another issue when I am trying to access this URL , special character in URL are getting encoded and it doen't work.

http://<URL>?&host_token=xxx&form.time_token.earliest=1618776000&form.time_token.latest=1618863722&%26form.MACHINE_TOKEN%3Dhp548srv%2C%26form.MACHINE_TOKEN%3Dhp675srv

Re: Select Multiselect value from URL Token

AKG1_old1 — Mon, 19 Apr 2021 21:44:59 GMT

This post is to pass multiselect value to drilldown dashboard but my requirement is other way. I want token to be sent to drilldown dashboard and in drilldown dashboard I have multiselect.

Re: Select Multiselect value from URL Token

ITWhisperer — Mon, 19 Apr 2021 22:00:30 GMT

The first part sets up a token from the multi-select. This token is constructed using a mvjoin. If you look at what will actually be passed in the drilldown it looks like this

/app/yourapp/drilldown?form.drilldownmulti=$drilldownmulti|n$

The drilldownmulti token has been set up with all the values in the multi-select, delimited by "&form.drilldownmulti=". So, for example, if the selected values were A, B, C, the final URL would be

/app/yourapp/drilldown?form.drilldownmulti=A&form.drilldownmulti=B&form.drilldownmulti=C

This then appears in the drilled down dashboard in the drilldownmulti multi-select input as A, B and C being preselected.

So, for your case, you need to call your URL with multiple instances of form.MACHINE_TOKEN=<value> separated by &

Hopefully, that's a bit clearer

Re: Select Multiselect value from URL Token

AKG1_old1 — Mon, 19 Apr 2021 22:11:19 GMT

i tried similar approach but issue is when we click to reach drilldown dashboard it convert & and = charater to encoded format and it doent work.

http://<url>?&host_token=xxx&form.time_token.earliest=1618776000&form.time_token.latest=1618863722&%26form.MACHINE_TOKEN%3Dhp548srv%2C%26form.MACHINE_TOKEN%3Dhp675srv%2C%26form.MACHINE_TOKEN%3Dmx24637vm%2C%26form.MACHINE_TOKEN%3Dmx24638vm

Re: Select Multiselect value from URL Token

ITWhisperer — Mon, 19 Apr 2021 22:16:21 GMT

If you have the value in a token, use the |n filter to prevent escaping (as shown in the example answer and above)

Re: Select Multiselect value from URL Token

manjunathmeti — Tue, 20 Apr 2021 07:06:29 GMT

Use CDATA wrapper to make sure that the & symbol is interpreted correctly

If this reply helps you, a like would be appreciated.