Splunk DB Connect 1: How to create a search form that runs a dbquery when username is a variable?

[abovebeyond]

Hi,

I'm trying to create a search form that runs a dbquery when username is a variable.

I tried with this code without a success:

<form>
  <label> Users </label>
  <description/>

  <searchTemplate>
| dbquery "testdb" "select * from [vw_Getusers] 
Where username=$username$"
  </searchTemplate>


  <fieldset autoRun="True">


    <input type="text" token="username">
      <label>username</label>
      <default>admin</default>
      <suffix>*</suffix>
    </input>


    <input type="time" searchWhenChanged="true">
      <default>
        <earliestTime>-24h@h</earliestTime>
        <latestTime>now</latestTime>
      </default>
    </input>

  </fieldset>

  <row>
    <panel>

      <table>
        <option name="showPager">true</option>
        <option name="count">20</option>
      </table>
    </panel>
  </row>
</form>

Where is it failing?
Thanks

[abovebeyond · Accepted solution]

now its working, using the following code

<form>
  <label> Users </label>
  <description/>
  <fieldset>

   <input type="text" token="username">
     <label>Enter the value of Username</label>
   </input>
  </fieldset>

   <searchTemplate>
 | dbquery "testdb" "selectfrom [vw_Getusers] 
Where username='$username$'" 
     order by id desc 
   </searchTemplate>

  <row>
    <panel>
      <table>
        <option name="showPager">true</option>
        <option name="count">20</option>
      </table>
    </panel>
  </row>
</form>