Tuto WINDEV 25

176 Part 4: Full application with data Remark A popup menu is displayed when a right click is performed on the query result. You have the ability to export the result to: • an XLSX file (Excel). • a Word or OpenOffice file. • an XML file (eXtensible Markup Language). • a HFSQL file. 3. Close the window. Using parameters in the query In our example, the user will be able to select a value for the following search criteria: • Order status. • Order payment mode. • Order date. We must modify the query in order for these search criteria to correspond to the query parameters. ▶ To define the query parameters, display the description window of query: double-click the background of graphic query representation (or select "Query description" from the popup menu). ▶ To manage the "order status" parameter: 1. Select the Orders.Status item (in the middle of the screen). 2. Expand "Selection condition" and select "New condition". 3.  In the window that is displayed, we are going to specify that the selection condition corresponds to a parameter: • Select "Is equal to". • Select "the parameter". • The name of the parameter is automatically proposed: "ParamStatus".