web

You’re offline. This is a read only version of the page.

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

97

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

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

PJ JohnPaul 97 on at

Like (0)

Report

How to get user worker relation for past workers?

Thank you so much Andre.

Was this reply helpful? Yes No
Verified answer

André Arnaud de Cal... 298,933 Super User 2025 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;

Was this reply helpful? Yes No

Helpful resources

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1

CA Neeraj Kumar 2,258

#2

André Arnaud de Cal... 949 Super User 2025 Season 2

#3

Sohaib Cheema 631 User Group Leader

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans