...
The sample data service (NestedQuerySample) contains the following queries.operations:
- employeesInOfficeSQL - Takes in an office code and prints the details of all the employess in that office.
- listOfficesSQL - Lists all the offices in the database. When office information is printed, all the employees that belong to an office are also printed using a nested query, which refers to the employeesInOfficeSQL query.
- customerNameSQL - Takes in the customer number as a parameter and returns the customer name. In the result section of this query, there is no "rowName" defined; only an element wrapper. With this option, a separate element will not be created for every record in the result. But However, the record content will be directly added to the outer element. This is best used in a query where , there is only one record to be returned.
- customerOrdersSQL - Prints the details of all the orders that are in the database. In the result elements, a nested query which references the customerNameSQL query is used. In this way, the name of the customer who placed the order can also be returned with the order details.
...
- 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.
- Nested query based operation invocation using Operation invoking the "listOfficesSQL" query:
- Nested query based operation invocation using Operation invoking the "customerOrdersSQL" query:
- Nested query based operation invocation using Operation invoking the "customerNameSQL" query:
- Nested query based operation invocation using Operation invoking the "listOfficesSQL" query: