You have a test that fetches all sales order that fail some rule, in our example we check if discount is too high.
You want all department heads to be responsible and receive emails but you also want the sales person in each case to be CC in the email to the department head.
Here is our query:
You map the department head from Exception Manager Properties User Mapping, selecting a column containing user information.
Note that you can map to custom user information by using External User mapping, for example if you want to map to user data in your CRM system.
To add the sales person to the email, open the Email tab and select your sales person column from your query.