- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎08-14-2023 07:39 PM
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?
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎08-14-2023 09:48 PM
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎08-14-2023 09:48 PM
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎08-15-2023 01:51 PM
That makes sense. Thanks Maik.