Movers - Old information for a notification

[PiouPiou]

Hello,

I'd like to send an email when a mover is detected. And in my email template, I'd like to put in the old and the new information of the user. For example, if a mover is detected and the manager of the user has changed, in my email template, I'd like to have something that would contain: 

• " User's old manager: John Doe
• User's new manager: Indiana Jones"

In sum,  it is the "John Doe" in my example that I'm unable to get as the user's manager is Indiana Jones when the email is sent.

So would you know if there is a way to get the informations that were there before an update and put them in the email template with the new informations?       

Thank you in advance!                                          

[nimitdave]

You can try creating an analytics control as below, changelog column has details of the updates:

select u.username, u.userkey, uh.changelog from users u inner join usershistory uh on u.userkey=uh.userkey where username=${username}

And then you can deserialize the contents.

[PiouPiou]

Thank you!!