Can you change the base search depending on a drop down value?

[replicant]

I have a dashboard that uses a dbxquery in the base search.  I would like to make the dashboard "bilingual".

Is it possible to alter the behavior of the dashboard and select a different base search depending on the value of a drop down or radio button?

For example, selecting the first of the two options should have this base search be used:

<search id="base1">
<query>| dbxquery shortnames=true output=csv connection="CON_1" query="use [DB1] select TimeRaised as 'TimeTriggered', ...</query>

...while selecting the 2nd of the two options would use this one:

<search id="base1">
<query>| dbxquery shortnames=true output=csv connection="CON_2" query="use [DB2] select TimeRaised as 'TimeTriggered', ...</query>

[replicant]

@richgalloway - Perfect.  Karma given.  Thanks.

[richgalloway · Accepted solution]

If your problem is resolved, then please click the "Accept as Solution" button to help future readers.

[richgalloway]

Rather than change the base search, consider changing parameters of the search.  If this is the base search

<query>| dbxquery shortnames=true output=csv connection=$CON|S$ query="use [$DB$] select TimeRaised as 'TimeTriggered', ...</query>

then you just need the dropdown selector to set the $CON$ and $DB$ tokens to the appropriate values.

<input type="dropdown" ...>
  ...
  <change>
    <condition label="Choice 1">
      <set token="CON">CON1</set>
      <set token="DB">DB1</set>
    </condition>
    <condition label="Choice 2">
      <set token="CON">CON2</set>
      <set token="DB">DB2</set>
    </condition>
  </change>
</input>