Incidents or Tasks "updated by" report

[Blair Loveday]

Hey Team.

I am trying to create some reports for BAU activities and the Updated by is weird so want to check if I am doing anything wrong.

If I used "Created by" or "Closed by" then it displays the agents name.  e.g FirstName LastName

If I used "Updated by" it displays the agents email address.  e.g. firstname.lastname@domain.com

I am nervous that it is looking at something different and not the best way to grab this information.

I tried on the task table and the incident table, same result.

Anyone else done a report similar to this?

[Maik Skoddow · Accepted solution]

Hi

this is due to the "String" data type of the fields "Created by" and "Updated by". They get populate the "username" value of the related user record and thus you cannot dot-walk these fields.

On the other hand fields like "Closed by" are real reference fields and therefore can be used for dot-walking.

This is by design and cannot be changed.

Maik

[Blair Loveday]

That makes sense.  Thanks Maik.