1 <!--menu--> 2 <form action="<!--self-->" method="POST" target="_blank"> 3 <input type="hidden" name="key" value="<!--key-->"> 4 <input type="hidden" name="action" value="runquery"> 5 <!--joinlist--> 6 <p>Please choose how you want to filter the results.</p> 7 <table class="inputtable"> 8 <!--criterialist--> 9 </table> 10 <p>Grouping options.</p> 11 <table class="inputtable"> 12 <tr> 13 <th>Function</th> 14 <td> 15 <select name="groupfunc"> 16 <option value=""></option> 17 <option value="MIN">Minimum</option> 18 <option value="MAX">Maximum</option> 19 <option value="COUNT">Count</option> 20 <option value="AVG">Average</option> 21 <option value="SUM">Sum</option> 22 <option value="STD">Standard deviation</option> 23 <option value="BIT_OR">Bit Or</option> 24 <option value="BIT_AND">Bit And</option> 25 </select> 26 <select name="funcfield"> 27 <option value=""></option> 28 <!--orderbylist--> 29 </select> 30 </td> 31 </tr> 32 <tr> 33 <th>Group by</th> 34 <td> 35 <select name="groupby"> 36 <option value=""></option> 37 <!--orderbylist--> 38 </select> 39 </td> 40 </tr> 41 </table> 42 <p>Extra query options.</p> 43 <table class="inputtable"> 44 <tr><th>Distinct</th><td><input type="checkbox" name="distinct"></td></tr> 45 <tr> 46 <th>Order</th> 47 <td> 48 <select name="orderby"> 49 <option value=""></option> 50 <!--orderbylist--> 51 </select> 52 <input type="checkbox" name="desc">DESC 53 </td> 54 </tr> 55 <tr><th>Limit</th><td><input type="text" name="limit" size="5"></td></tr> 56 </table> 57 <br> 58 <table class="inputtable"> 59 <tr><td><input type="submit" value="Continue"></td></tr> 60 </table> 61 </form>