Integration Center Direct Reports

[clumbert]

I am building a file using Integration Center. One of the fields that I need to include is whether the employee is a manager. In Report Center, there is a field called 'Direct Reports' that returns the number of employees that report to the employee. I think I could use this with some logic that if the number is greater than 0, then the employee is a manager. However, I cannot seem to get this same return value in Integration Center.

Has anyone else had a similar requirement? I do see 'directReports in UserPermissions' within Integration Center, but it is not returning the values that I see in Report Center.

Any suggestions would be appreciated.

Thank you,

Cindy

[samueldenys]

Hi Stiaan and Jenny,

Thank you for this answer. Do you have any idea on how to get a list of Line Manager even if they do not have any direct report?
Thank you,

Samuel

[Stiaan]

For some you can't see directReports in the search, but it's there.

In the field selector, choose any field on the User entity, then go to the Entity Tree View and scroll down until you see the directReports relation. You could choose userId as the field association and then you could use this field in a calculation to check if the top of stack record value is not empty, the employee is a manager of a least one other employee.

[jenny_geipel]

Thanks a lot. I'm searching for exactly this solution 🙂 and it works.