How to get user worker relation for past workers?

(0) Share

Report

Posted on by PJ JohnPaul

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 (2)

All responses (32)

Answers (3)

Sort by

Verified answer

André Arnaud de Cal... Super User 2025 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!
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;

..

2 people found this reply helpful.

Was this reply helpful? Yes No
PJ JohnPaul on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you so much Andre..

2 people found this reply helpful.

Was this reply helpful? Yes No
#Jahanvi Arora on at

Like
a
(0)

Report
Copy link

Link copied!

testing @soundari anand

2 people found this reply helpful.

Was this reply helpful? Yes No
#Jahanvi Arora on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @harini24, How to create post?

@#Jahanvi Arora

Was this reply helpful? Yes No
Suggested answer

#Jahanvi Arora on at

Like
a
(0)

Report
Copy link

Link copied!

testing

Was this reply helpful? Yes No
Suggested answer

#Jahanvi Arora on at

Like
a
(0)

Report
Copy link

Link copied!

testing for suggested ans

Was this reply helpful? Yes No
Suggested answer

#Jahanvi Arora on at

Like
a
(0)

Report
Copy link

Link copied!

testin1

Was this reply helpful? Yes No
Suggested answer

#Jahanvi Arora on at

Like
a
(0)

Report
Copy link

Link copied!

testing1

Was this reply helpful? Yes No
Suggested answer

#Jahanvi Arora on at

Like
a
(0)

Report
Copy link

Link copied!

testing 03 dec @#Jahanvi Arora @muskan @Jahanvi

Was this reply helpful? Yes No
Verified answer

#Jahanvi Arora on at

Like
a
(0)

Report
Copy link

Link copied!

test test 03 dec 0.1 @Jahanvi

@harini24

testing @mentions

@#Jahanvi Arora

Was this reply helpful? Yes No