Just as Input mapping allows you to add parameters to a query, output mapping determines how the output of a query should be presented. The
| Table of Contents | ||||
|---|---|---|---|---|
|
Generating output mappings
| Note |
|---|
Note that this option is only available for |
If you have defined an SQL query, you can generate output mappings corresponding to the fields specified in the query by clicking Generate Response. In the example shown below, there is an SQL query that needs to output values for the customernumber and customername fields in the customers table.
When you click Generate Response, output mappings will be created automatically for the specified fields as shown below.
Adding output mappings manually
If you are manually adding output mappings, you need to update the Result (Output Mapping) section appears in the Queries page as given the Queries page shown below. Once you have entered the main output mapping options, click Add New Output Mapping to open the the Edit Output Mapping page page.
The following following options are available for creating an output mapping:
| Table of Contents | ||||
|---|---|---|---|---|
|
...
- As shown below, the user roles available in your system will be listed. You can select the required user roles for the output mapping.
- User roles you selected will be assigned to the output mapping as show below.
