Manager Direct Employees

(0) Share

Report

Posted on by Walid12

Hi,

I want to get all the direct employees of a manager based on manager personnel number or user id,

could you help me please.

I have the same question (0)

All responses (6)

Answers (0)

Gunjan Bhattachayya 35,423 on at

Like (0)

Report

RE: Manager Direct Employees

Walid,

Do you need this for reporting or for any configuration>

Was this reply helpful? Yes No
Walid12 21 on at

Like (0)

Report

RE: Manager Direct Employees

Thanks @Gunjan for you reply,

I need it for some customization in EP.

Was this reply helpful? Yes No
Suggested answer

Gunjan Bhattachayya 35,423 on at

Like (0)

Report

RE: Manager Direct Employees

Walid,

You can take a look at this method -

\Classes\HcmPositionHierarchyViewController\loadPositions

The query used in the method is used to populate the organization hierarchy. Should help you with finding direct employees under a manager.

Was this reply helpful? Yes No
Suggested answer

Sukrut Parab 71,699 Moderator on at

Like (0)

Report

RE: Manager Direct Employees

Query from below link should also help you . It just select one record but you can do changes to get all positions

community.dynamics.com/.../get-report-to-position-worker-name-with-employment-recid-sql-query

Was this reply helpful? Yes No
Walid12 21 on at

Like (0)

Report

RE: Manager Direct Employees

Thanks Surkut for the reply,

but it is SQl query it is not working in X++ editor specially the joins.

Was this reply helpful? Yes No
Sukrut Parab 71,699 Moderator on at

Like (0)

Report

RE: Manager Direct Employees

Its just for your reference and its very straightforward. . You have to convert that to x++ query. Converting SQL query to x++ query shouldn't be difficult.

Was this reply helpful? Yes No