Tuto WEBDEV 25

176 Part 5: Let’s continue the development ▶ We are now going to define a condition on the payment mode. The "PaymentMode. PaymentModeID" item must not be displayed in the query result but a condition must be applied to it. To do so, it will be made invisible. 1.  To avoid displaying the "PaymentMode.PaymentModeID" item in the result: • Click the eye ( ) corresponding to the "PaymentMode.PaymentModeID" item in the list of query elements (in the middle of the screen). • In the menu that is displayed, select "Don’t display". 2.  To define a selection condition on the "PaymentMode.PaymentModeID" item: • Select the "PaymentMode.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". 3. Validate the definition of selection condition. ▶ The last selection condition to define affects the order amount. In fact, we are going to define two selection conditions in order to specify a minimum price and a maximum price. 1. Select the "Orders.TotalIOT" item in the list of query elements. 2. Display the popup menu of item (right mouse click) and select "Selection condition .. New condition". 3.  In the window that is displayed: • Select the condition "Is greater than or equal to". • Click "the parameter". • Specify the parameter name: "ParamMinPrice". 4. Validate the definition of selection condition. 5. Define once again another condition on the same "Orders.TotalIOT" item: display the popup menu of item (right mouse click) and select "Selection condition .. New condition". 6.  In the window that is displayed: • Select the condition "Is less than or equal to". • Click "the parameter". • Specify the parameter name: "ParamMaxPrice". 7. Validate the definition of selection condition.