Report to know resources logging Time to unassigned Tasks | Community
Skip to main content
M
meshackOm
Level 3
August 4, 2023
Solved

Report to know resources logging Time to unassigned Tasks

  • August 4, 2023
  • 1 reply
  • 2435 views

Hi Community,

I'm trying to create a report to identify resources that logged time to unassigned tasks. Please can you advise on the best filters to use in this scenario? 

Thanks 

Mesh 

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by NicholeVargas

If you are not assigning teams to tasks, then you can create an Hour Report and add the following filters, separated by an AND statement:

Task > Role ID > Is Blank
Task > Assigned To ID > Is Blank
Hour > Hour Type ID > Task Time

That should provide you with the details of the hours logged to unassigned tasks. If that's not exactly what you were looking for, just let me know!

 

1 reply

NicholeVargas
Adobe Employee
NicholeVargasAdobe EmployeeAccepted solution
Adobe Employee
August 4, 2023

If you are not assigning teams to tasks, then you can create an Hour Report and add the following filters, separated by an AND statement:

Task > Role ID > Is Blank
Task > Assigned To ID > Is Blank
Hour > Hour Type ID > Task Time

That should provide you with the details of the hours logged to unassigned tasks. If that's not exactly what you were looking for, just let me know!

 

    M
    meshackOmAuthor
    Level 3
    August 6, 2023

    @nicholevargas Thanks so much for your contribution. I applied the filters but is only pulling resources that logged time to unassigned parent tasks. but resources logging time to unassigned sub-tasks is Not pulling the. What do you advise? 

    Any contribution from any other member of the community is very appreciated. 

    Thanks 

    Mesh 

    NicholeVargas
    Adobe Employee
    NicholeVargasAdobe Employee
    Adobe Employee
    August 10, 2023

    To close the loop here and to share the results with everyone else on the Community, 

    if you want to see a list of hours logged to tasks where the person who logged the hour is NOT assigned to the task, then you can create an Hour Report, go to the Filters tab and switch to text mode and paste in the following. That should do the trick!

    EXISTS:1:$$EXISTSMOD=NOTEXISTS

    EXISTS:1:$$OBJCODE=ASSGN

    EXISTS:1:assignedToID=FIELD:ownerID

    EXISTS:1:taskID=FIELD:taskID

    All records (results) should be hours logged to a task where the hour owner isn't assigned to the task. If they become assigned, the Hour will fall off the report. 


    @meshackom I'm running into issues with my direct messages, so see above for the text mode filter you can use to show hours logged to tasks where the hour owner is not assigned to the task.

    For a separate reporting showing hours logged to tasks with no assignees, you can use the following, separated by AND statements. 

    Task > Role ID > Is Blank
    Task > Assigned To ID > Is Blank
    Hour > Hour Type ID > Task Time

    Terms & ConditionsAccessibility statement

    Loading footer...