Show TOC

Procedure documentationCreating a Query that Returns All Items of an Order Locate this document in the navigation structure

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   Development Component   Build   and then OK.