Greetings. We are creating an approval workflow for Time-Off Requests. The workflow will be applied to a calendar in each Unit's sub-site of the Division's parent site. As our Exchange environment does not have the Manager field populated, we have a Contact list in the parent site that contains each worker and their manager. Rather than create a Contacts list for each site and have to maintain them, we would like to reference the Contact list in the parent site in each of the sub-site worklows.
I found a tutorial on how to use CAML in the Query List Action, but am having trouble figuring out how to form the query to retrieve the Manager of the person requesting time off. Here is the tutorial: Nintex Workflow – Query a List in Another Site - SharePoint Blog. The tutorial helps, but I need to retrieve the name of The Manger from the list when the RequestorName from the Calendar list matches the Name of teh Worker in the Contact list.
In any event, any help on how to accomplish retrieving teh Manager Name of a Worker from a list in another site would be helpful. Thanks.