Tuto WINDEV 25

Part 4: Full application with data 177 Remark We advise you to keep "Param" as the prefix of the query parameters. This allows you to easily find them in the code editor. To find a query parameter, simply type ’Param’ and the completion feature of the code editor will propose all the parameters. 4. Validate the condition description window. The number "1" appears on the right of "Orders. Status" item, indicating that a selection condition was defined. ▶ We are now going to define a condition on the payment mode. This item is not found in the query result but a condition will be applied to it. To do so, the item will be included in the query result and it will be made invisible so that it is not visible in the result. 1. On the left part of the query description window, in the "Orders" data file, double-click on the item "PaymentMethodID". The "PaymentModeID" item appears in the list of query elements. 2.  To avoid displaying this item in the result: • Click the icon found on the right of item. • In the menu that is displayed, select "Don’t display". 3.  To define a selection condition on the "Orders.PaymentModeID" item: • Select the "Orders.PaymentModeID" item (in the middle of the screen). • Expand "Selection condition" and select "New condition". • In the window that is displayed, specify that the selection condition corresponds to a parameter: • Select "Is equal to". • Select "the parameter". • Specify the parameter name: "ParamPaymentModeID". 4. Validate the definition of selection condition.