
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