- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-08-2023 09:31 AM
Hi all
I would like to display in my reports the name of the user behind the "Created by" or the "Update by". Is there a way to get it a a report (whatever is the table) ? I do see the "+" that could give us the opportunity to go into the user table. Thanks
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-08-2023 10:09 AM - edited 02-08-2023 10:10 AM
sys_created_by is a String field and not a reference, therefore there will be no + to dotwalk it. It is an Audit field that just stores the user_id of the person who did the create/update. Afaik, there is no way to do that unless you create a view with a join on the user table.
If it is important to the process the Created By should be captured in Opened By and updated_by should be captured in Closed By (as it is in INC Mgmt)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-08-2023 10:09 AM - edited 02-08-2023 10:10 AM
sys_created_by is a String field and not a reference, therefore there will be no + to dotwalk it. It is an Audit field that just stores the user_id of the person who did the create/update. Afaik, there is no way to do that unless you create a view with a join on the user table.
If it is important to the process the Created By should be captured in Opened By and updated_by should be captured in Closed By (as it is in INC Mgmt)