topic Using SimpleXML, how do you populate singlevalue underLabel option with value from search? in Dashboards & Visualizations

Using SimpleXML, how do you populate singlevalue underLabel option with value from search?

jpass — Thu, 23 Mar 2017 13:05:02 GMT

Is it possible to output other values from a search that populates a singlevalue element in my dashboard? What I want is to include a custom description under the singlevalue.

example:

 | EVAL singlevalue="5" | EVAL description="this is a description"  | TABLE singlevalue, description

 <option name="underLabel">$search.description$</option>

 Output:
 5
 this is a description

Re: Using SimpleXML, how do you populate singlevalue underLabel option with value from search?

woodcock — Thu, 23 Mar 2017 14:10:01 GMT

Not exactly, but this should be good enough for you unless you are really picky:

<dashboard>
  <label>Demonstration of a single value description</label>
  <description>description on single value panel</description>
  <row>
    <panel>
      <title>$description$</title>
      <single>
        <title>$description$</title>
        <search>
          <query>|makeresults | eval singlevalue="5" | eval  description="this is a description"  | table singlevalue description</query>
        <finalized>
          <set token="description">$result.description$</set>
        </finalized>
        </search>
      </single>
    </panel>
  </row>
</dashboard>

Re: Using SimpleXML, how do you populate singlevalue underLabel option with value from search?

DMohn — Thu, 23 Mar 2017 16:09:05 GMT

I assume this is what you intended:

<dashboard>
  <label>Result Token</label>
  <row>
    <panel>
      <title>Set underLabel by result</title>
      <single>
        <search>
          <query>| makeresults | eval label="MyLabel" | eval value="MyValue" | table value, label</query>
          <sampleRatio>1</sampleRatio>
          <done>
            <set token="testtoken">$result.label$</set>
          </done>
        </search>
        [...] other options [...]
        <option name="underLabel">$testtoken$</option>
      </single>
    </panel>
  </row>
</dashboard>

You have to set another token with the search results, as simpleXML seems to not be able to access the search results directly.

Re: Using SimpleXML, how do you populate singlevalue underLabel option with value from search?

jpass — Thu, 23 Mar 2017 17:02:43 GMT

Easy enough. Thanks!