Creating a Query that Returns the Orders

Procedure

1. In the Services Explorer , in the context menu of order_srv , choose New  Service.

2. For Name , enter OrderService and , for Description , This service contains queries and custom methods for accessing Orders .

3. Choose Finish .

   The Services Editor opens

4. In the Services Editor of the service OrderService , switch to the Operations tab.

5. Add a new operation by choosing Add .

6. For Operation Type , select Query . For Name enter getOrderHeaders . For Description, enter This query returns the headers of all local orders .

7. Choose Next .

8. Choose Add Input .

9. In the table, choose Add to create an input parameter. For Name , enter pi_customerid and, for Type , select string . Choose OK .

10. Choose Add Output , select OrderOrderHeader and choose OK .

11. Choose Add filters . From the top two dropdown boxes, select OrderOrderHeader and CustId. From the middle dropdown box, select = (equals). From the bottom two dropdown boxes, select From Input Parameter and pi_customerid .

12. Choose Finish to close the wizard.

13. Save your work.

14. Build the component: In the context menu of the order_srv component , choose Development Component  Build.

For more information, see Creating Queries and Custom Operations .