web

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

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?

(2) Share

Report

Report

Posted on by PJ JohnPaul

102

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

Categories:

Development / Customization / SDK

All responses Img

All responses (3)

Answers Img

Answers (2)

Jahanvi on at

Like (0)

Report

How to get user worker relation for past workers?

test
Verified answer

PJ JohnPaul 102 on at

Like (1)

Report

How to get user worker relation for past workers?

Thank you so much Andre.
Verified answer

André Arnaud de Cal... 283,862 Test role Public on at

Like (1)

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

Quick Links

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

#1

Jahanvi 35

#2

PJ JohnPaul 5

#3

Anton Venter 4 Moderator

Last month Overall leaderboard

Featured topics

Test Comment 26-09-2024 16:14pm

Product updates

Dynamics 365 release plans