Passing values to another dashboard and using the same in search

[smanojkumar]

Hi There!
   I need to pass a token form one dashboard to another dashboard when clicking its pie chart
 Input in dashboard 1

</input>
<input type="multiselect" token="choose_office" searchWhenChanged="true">
<label>Front/Back office</label>
<choice value="Front Office">Front Office</choice>
<choice value="Back Office">Back Office</choice>
<initialValue>Front Office,Back Office</initialValue>
<default>Front Office,Back Office</default>
<valuePrefix>"</valuePrefix>
<valueSuffix>"</valueSuffix>
<delimiter>, </delimiter>
</input>

one of the searches in dashboard 1

`compliance_op`
| search office IN ($choose_office$)
| chart count by $scope$global
| sort $scope$global

My link to next dashboard is 

<drilldown>
<link target="_blank">/app/SAsh/operational_beautiful?form.choose_office=$choose_office$&amp;form.machine=$machine$&amp;form.origin=$origin$&amp;form.country=$country$&amp;form.cacp=$cacp$&amp;form.scope=$scope$</link>
</drilldown>

Multiselect in dashboard 2

<input type="multiselect" token="office_filter" searchWhenChanged="true">
<label>Front/Back Office</label>
<choice value="Front Office">Front Office</choice>
<choice value="Back Office">Back Office</choice>
<choice value="Unknown">Unknown</choice>
<prefix>office IN (</prefix>
<suffix>)</suffix>
<initialValue>Front Office,Back Office,Unknown</initialValue>
<valuePrefix>"</valuePrefix>
<valueSuffix>"</valueSuffix>
<delimiter>, </delimiter>
<change>
<eval token="office_filter_drilldown">mvjoin('form.office_filter',"&amp;form.office_filter=")</eval>
</change>
</input>

search in dashboard 2

`compliance_ap`
| search office IN ($choose_office$)
| chart count by $scope$global
| sort $scope$global

I'm facing error in search of dashboard 2.

Thanks!

[smanojkumar]

Hi @ITWhisperer !

   Thanks for your response!

   It is working fine, it always selected two values in dashboard 2 even if we are selecting one value in dashboard 1, 
   For Eg. If we are selecting "Front Office" in Dashboard 1, It shows both values "Front Office" and "Back Office" in Dashboard 2.

Thanks!

[ITWhisperer]

The tokens passed in the url need to be constructed from the multi-select input not hard coded

[smanojkumar]

Hi @ITWhisperer 
   
   I tried few way, I didn't got it.

<condition match="isnull($office_filter$) == &quot;Front_Office*&quot;">
<set token="office_filter_drilldown">form.office_filter=Front%20Office</set>
</condition>
<condition match="isnull($office_filter$) == &quot;Back_Office*&quot;">
<eval token="office_filter_drilldown">form.office_filter=Back%20Office</eval>
</condition>
<condition match="isnull($office_filter$) == &quot;Front_Office*&quot; AND == &quot;Back_Office*&quot;">
<eval token="office_filter_drilldown">form.office_filter=Front%20Office&amp;form.office_filter=Back%20Office</eval>
</condition>

   can you please share that as well.

Thanks in Advance!

[ITWhisperer]

Try something like this

<input type="multiselect" token="choose_office" searchWhenChanged="true">
<label>Front/Back office</label>
<choice value="Front%20Office">Front Office</choice>
<choice value="Back%20Office">Back Office</choice>
<valuePrefix>form.choose_office=</valuePrefix>
<valueSuffix></valueSuffix>
<delimiter>&amp;</delimiter>
</input>

[smanojkumar]

Hi @ITWhisperer ,

   It is fine but the prefix "form.office_filter=" is affecting the token that is used in search and the link is not expected.

Here is the link

&form.office_filter%3DBack%20Office%26form.office_filter%3DFront%20Office=&

If I'm using this instead, it works

&form.office_filter=Back%20Office&form.office_filter=Front%20Office=&

= is replaced by %3D in first link, & is replaced by %26

Can you  please help me in this!

Thanks!

[ITWhisperer]

How are you using the token in the link?

[smanojkumar]

Hi @ITWhisperer 

   I'm just passing the token in link

$office_filter$

<link target="_blank">/app/SAsh/details?form.compliance_filter=$click.value$&amp;form.timerange=$timerange$&amp;form.antivirus_filter=*&amp;$office_filter$&amp;form.machine=$machine$&amp;form.origin=$origin$&amp;form.scope=$scope$</link>

[ITWhisperer]

Multi-selects settings are passed in URLs by repeating the token with each value that has been selected

<link target="_blank">/app/SAsh/operational_beautiful?form.choose_office=Front%20Office&amp;form.choose_office=Back%20Office&amp;...