topic Form and inputlookup in Dashboards & Visualizations

Form and inputlookup

DTERM — Wed, 21 Dec 2011 21:55:04 GMT

What is the problem with the following form? The form utilizes inputlookup to generate a dropdown. The dropdown list works. However the query portion is not working out. Where is this problem? Thanks in advance.

    <form class="formsearch">
<label>Top H</label>
<!--
<searchTemplate>index=myapp supportGroup="$VGroup$" | top 15 tgtHostname</searchTemplate> 
<searchTemplate>index=myapp supportGroup="$VGroup$"</searchTemplate>
<searchTemplate>index=myapp supportGroup="$VGroup$" | top 15 "$VGroup$"</searchTemplate>
<searchTemplate>index=myapp supportGroup=$VGroup$ | top 15 $VGroup$</searchTemplate>
<searchTemplate>index=myapp supportGroup=$VGroup$ | top 15 supportGroup</searchTemplate>
-->

<searchTemplate>index= myapp supportGroup=$VGroup$</searchTemplate>

<fieldset>
   <input type="dropdown" token="supportGroup">
   <label>Select Support Group</label>
   <choice value="*">All</choice>
   <populatingSearch fieldForValue="VGroup" fieldForLabel="VGroup"><![CDATA[|inputlookup supportgroup.csv | fields + VGroup]]></popula
tingSearch>
  </input>

    <input type="time">
        <default>Last 7 days</default>
    </input>
</fieldset>

  <row>
    <chart>
      <title>Top Hosts</title>
      <option name="charting.chart">pie</option>
      <option name="drilldown">all</option>
    </chart>
    <chart>
      <title>Top Hosts</title>
      <option name="drilldown">all</option>
    </chart>
  </row>
  <row>
    <table>
      <title>Top Hosts</title>
      <option name="drilldown">all</option>
    </table>
  </row>


</form>

Re: Form and inputlookup

lguinn2 — Wed, 21 Dec 2011 22:16:39 GMT

I think it should be

<searchtemplate>index= myapp supportGroup="$supportGroup$"</searchtemplate>

I put quotes around variables as a best practice. They aren't required.

Re: Form and inputlookup

DTERM — Thu, 22 Dec 2011 19:41:36 GMT

The search comes up empty. It did not work. Any other ideas?

Re: Form and inputlookup

lguinn2 — Thu, 22 Dec 2011 20:51:28 GMT

What do you get if you type

index=myapp supportGroup=XXX

in the search box, where XXX is the name of a valid support group?

Re: Form and inputlookup

DTERM — Thu, 05 Jan 2012 17:07:17 GMT

Your suggestion works.

This is the condensed script. Any idea why this does not work? The drop down works, however the query is blank.

index=MyApp supportGroup=$VGroup$

Select Support Group All |inputlookup supportgroup.csv | fields + VGroup Last 7 days

Re: Form and inputlookup

DTERM — Thu, 05 Jan 2012 18:31:05 GMT

Thanks. It finally worked.

Re: Form and inputlookup

rroberts — Thu, 05 Jan 2012 18:37:57 GMT

Couple of things:

1. Element and Attributes are case sensitive should be fieldForValue and fieldForLabel and check the elements searchTemplate and populatingSearch.

2. Your token is VGroup in your searchTemplate. Should match your token attribute value in your input element ie token="VGroup"

3. fieldForValue and fieldForLabel should be "supportGroup"