I have a user that initiates a workflow by adding a document to a SharePoint library. The workflow assigns a task to an engineer of the initiator's choosing (via dropdown when the file is uploaded to the library). Once the engineer complete's their task, a new task needs to be generated for the engineer's manager. I can't use the manager context property because I don't want the workflow initiator's manager, but the task assignee's manager.
I can use the "query LDAP" action, but it returns the manager's distinguished name. We could use regex to pull out the CN, but the problem with that is some users may have the same CN. We need something more unique.
We do not have the Enterprise version so we do not have the query user profile action available to us. Is there a different way to find the manager of a task assignee? Thanks!