Problem with email template showing change in assigned user

[kwoitena]

In the email template, at least in version 4.5.1, when we wanted an email sent out to report that an account had changed between one user and another, we would use this string:

Account {::future::Accounts::name::} was changed from {::past::Accounts::Users::full_name::} to {::future::Accounts::Users::full_name::}

What we're seeing now in 5.0.0i when the email is sent out is:

The account Indoff was changed from {::past::Accounts::Users::full_name::} to Tara

What is taking place is, Tara is modifying the account assigning it to another user, Vanessa and the code for

{::past::Accounts::Users::full_name::}

is not displaying any information.

These changes were made to the template because the old templates from 4.5.1 were displaying the long string of characters found in the database key and were unintelligible to all of our users.

I guess the question I'm trying to answer is: what is the proper string to display the full name (or even user name) of who accounts were assigned to previously and who they are assigned to presently when that change happens?

We are running:

• CentOS 5.2
• Sugar 5.0.0i Pro
• Apache 2.2.3
• PHP 5.2.6
• MySQL 5.0.58

[kwoitena]

This bug appears to be fixed in the 5.2.0a release. We're currently testing to verify.

[kwoitena]

I tested it in the 5.2.0a release and the problem still exists. There are some updates to this problem. Now, if I have more than 2 triggers (i.e. if the assigned to field is changed, and is changed by a specific user) then the workflow does not execute. The email sent out in the Alerts Template is still either showing the code {:ast::Accounts::assigned_user_name::} or nothing at all.

[kwoitena]

I've narrowed down a sort-of fix to this. In 5.2.0a, I can set

{::future::Accounts::assigned_user_name::}

and get the current user the account is assigned to. The string

{::past::Accounts::assigned_user_name::}

displays nothing. I'd like to take a look in the code to see where these queries to the DB are defined. Does anyone know where to find these?