News and Announcements icon

Dynamics 365 CommunityForums Finance | Project Operations, Human Resources, ... How to get user worker...

Finance | Project Operations, Human Resources, ...

Answered

How to get user worker relation for past workers?

(0) Share

Report

Report

Posted on by PJ JohnPaul

93

Hi All,

I have written this piece of code to get user associated with worker.

Its working fine for active employees. For past worker the data not available in the dirperson table.

But in front end i can see the record with past worker associated with the user.

Please help me how to get user worker relation for past workers?

  DirPersonUser personUser  =   DirPersonUser::findParty(worker.Person); this.UserID               =   personUser.User;

Thanks in advance

All responses Img

All responses (2)

Answers Img

Answers (1)

PJ JohnPaul 93 on at

Like (0)

Report

How to get user worker relation for past workers?

Thank you so much Andre.
Verified answer

André Arnaud de Cal... 291,113 Super User 2024 Season 2 on at

Like (0)

Report
How to get user worker relation for past workers?

Hi JohnPaul,

The table DirPersonUser is a table enabled for date effectiveness. In that case, by default, it will only select records currently active. If the record for the worker has an end date before the current date or a start date after the current date, it will not be selected. You can use an alternative way of finding the record, providing a range for effective records, e.g.

DirPersonUser dirPersonUser; utcDateTime dateFrom; utcDateTime dateTo = DateTimeUtil::utcNow(); select firstonly validTimeState(dateFrom, dateTo) from dirPersonUser order by dirPersonUser.ValidTo desc where dirPersonUser.PersonParty == worker.Person; this.UserID = dirPersonUser.UserID;

Helpful resources

News and Announcements

Join us in the Community for an AMA: December 12th Register Today

Announcing Mentions and Quick Responses!

Quick Links

Leaderboard

#1

André Arnaud de Cal... 291,113 Super User 2024 Season 2

#2

Martin Dráb 229,918 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans