...
- Log in to the management console of your server and click List under Services in the navigator. The NestedQuerySample will be listed here.
- Click Try this service to open the TryIt tool.
- Select an operation and click Send to execute the operation. You will get the product list in the response as shown below.
- Operation invoking the listOfficesSQL query:
- Operation invoking the customerOrdersSQL query:
- Operation invoking the customerNameSQL query:
Enter "103" as the customer name and send the request as shown below.
- Operation invoking the employeesInOfficeSQL query:
First, see the result of "listOffices" operation to get the office code. Then, enter the office code ("1") and send the request as shown below.
- Operation invoking the listOfficesSQL query: