News and Announcements icon

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

Finance | Project Operations, Human Resources, ...

Suggested answer

How to get user history to persons?

(0) Share

Report

Report

Posted on by Mostafa Abd Elnasser

20

Hello All

How to get user history to persons?

    DirPersonUser   dirPersonUser;
    DirPerson       dirPerson;

    while select  DirPersonUser
    join DirPerson
        where DirPersonUser.PersonParty == DirPerson.RecId 
        && DirPersonUser.User == "Test"
    {
        info(strFmt("%1  %2  %3  %4 %5",DirPersonUser.User,DirPersonUser.userName(),DirPerson.Name,DirPersonUser.ValidFrom,DirPersonUser.ValidTo));
    }

I used this code to get the current relation , how I can find the oldest relation to a user .

Thanks

All responses Img

All responses (1)

Answers Img

Answers (0)

Suggested answer

ergun sahin 8,816 Moderator on at

Like (0)

Report

RE: How to get user history to persons?

Use validTimeState

docs.microsoft.com/.../effects-of-valid-time-state-tables-on-read-and-write-operations

www.avantiico.com/.../

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 293,027 Super User 2025 Season 1

#2

Martin Dráb 231,852 Most Valuable Professional

#3

nmaenpaa 101,156 Moderator

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans