Assigned to = hex values

[Cyberhippy]

Hi folks,

Working with Sugar Open Source 4.5.1g - I have about 5500 Targets in a Campaign that I assigned to different users back in January. We have resurrected the project, but now when I view the Target list the Assigned To field shows hex code like this: 84be08fd-4aac-c0fb-48e4-4743612b95b0 - rather than the user name.

Is there a simple solution to this situation that anybody has come across? I tried searching the Forums and didn't find anything...

Thank you,

Ken

[kuske]

The field assigned_to is a reference to the entries in the users table.
You get the assigned_user from the users table by relating the users.id column to the assigned_to field.

In the Studio - edit a module - leads - edit layout - list view
you should add "user" instead of "assigned to" to the default or additional fields. In "user" the name is retrieved.

[Cyberhippy]

Thanks for the response, unfortunately the problem is in the Targets list, not the Leads.

I went to the List View Editor:Targets page, I didn't see "User" as an Available option.

Problem persists.

[kuske]

In Version 4.5.1i the assigned user name is shown correctly.

In Studio it is named assigned_user_id but in the listview it shows the assigned user name.