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.
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.
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.
Thanks Surkut for the reply,
but it is SQl query it is not working in X++ editor specially the joins.
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
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.
Thanks @Gunjan for you reply,
I need it for some customization in EP.
Walid,
Do you need this for reporting or for any configuration>
André Arnaud de Cal...
293,025
Super User 2025 Season 1
Martin Dráb
231,837
Most Valuable Professional
nmaenpaa
101,156
Moderator