Creating a Query that Returns All Items of an Order

Procedure

  1. In the Service Explorer , in the context menu of the OrderService service, choose Add Operation .
  2. For Operation Type , select Query . For Name , enter getItemsByOrderId . For Description , enter This query returns all items of a given order . (The order is identified by its order ID.)
  3. Choose Next .
  4. Choose Add input .
  5. Choose Add .
  6. For Name , enter pi_orderid . For Type , enter string .
  7. Choose OK .
  8. Choose Add output , select OrderOrderItem , and choose OK .
  9. Choose Add filter .
  10. In the top two dropdown boxes, select OrderOrderItem and OrderId . In the middle dropdown box, select = (equals). In the bottom two dropdown boxes, select, From Input Parameter and pi_orderid .
  11. Choose OK .
  12. Choose Finish .
  13. Save your work.
  14. In the Services Explorer , in the context menu of the order_srv component, choose Start of the navigation pathDevelopment Component Next navigation step BuildEnd of the navigation path and then OK .