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
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>
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>