Report Question: Can you show all the people assigned to a task throughout its cycle if the owner changed multiple times?

Question

I am trying to use the Journal report feature to answer the following question:
 
"I want to see the history of task ownership. So if Mary originally owned it, then gave it to Kevin, who then passed it to Sally, then I'd want to see all three historical owners of the report."
 
Might be asking too much, but this group is really report savvy so hopefully you have insight!
 
Cheers,
Ryan

William-- · Accepted Answer

Not so sure about that, mostly because a Task/Issue >> Assignments is a One >> Many relationship, since a task/issue can be assigned to more than one user/role/team. So if one task is assigned to two users, that generates two assignments. Either one of those users could be the "last" assignment made and would probably appear to be arbitrary.

If you are using this report in a Dashboard Custom Section (report rows automatically filtering to the work object being viewed):
I think you could leverage an Assignment report with no filter (as opposed to a Journal Entry report with an Assignment filter). The Assignment report won't show assignments that have been removed, it will only show current assignments, who made them, when, and who's assigned, etc. If the task is only assigned to one user, then the assignment report will always show just the latest assignment made. If the task is assigned to multiple resources, the report will show the assignment details for each assigned resource. I think the part that speaks to your challenge is that it will be a clean list because won't show assignments that have been removed.

If you are using this as a standalone report:
I still think you're looking at an Assignment report because it can't show assignments that were removed, it can only show assignments that exist right now. The primary benefit of a Journal Entry report is showing historical details, and it seems like you don't need that for this challenge.

William-- · Answer

Hi Ryan,

First thing to check is confirmation that your system is tracking assignment changes. The below toggle needs to be enabled.

With that enabled, going forward you will see a history of assignment changes in each task or issue's update stream.

You can also create a Journal Entry report, as you started to do. The text mode filter needed is:

fieldName=status
fieldName_Mod=cine
subObjCode=ASSGN
subObjCode_Mod=eq

This will display all events in which an Assignment record was added, edited, or deleted (excluding simple status changes).

Then in your report view, you can add columns like "Project: Name" "Task: Name" "Edited By: Name" "Assigned To: Name" and more.

The most efficient way to use this type of report would be to add it to a dashboard; then add that dashboard as a Custom Section to your Tasks and/or Issues layout. Doing this will automatically filter the report results to only the task or issue being viewed. (You can also add the dashboard to your Projects layout to see all Assignment changes for the project).

If not embedding this report into your layout, you will likely need to add in additional filter logic to make sense of all the entries returned. Good luck!

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded