Hours Not Logged by Assignees to a Task or Request | Community
Skip to main content
J
JD_FCFS
February 6, 2026
Question

Hours Not Logged by Assignees to a Task or Request

  • February 6, 2026
  • 1 reply
  • 28 views

I need to see a report of Tasks and Requests that do not have hours logged by every assignee on each task/request so that we can see what Tasks/Requests are missing hours for which assignees.

There’s a thread here that identifies a way for an individual user to see their own Tasks that have not been assigned hours, but I can’t seem to find anything that shows how to see multiple users who do not have assigned hours.

 

Any advice is appreciated.

1 reply

skyehansen
Community Advisor and Adobe Champion
skyehansenCommunity Advisor and Adobe Champion
February 7, 2026

I don’t know of a good way to do this except through an assignment report -- well, actually, maybe 2 assignment reports -- one for tasks and one for issues.

 

In an assignment report though, you can maybe make an exists statement that looks for hours where the owner of the hour is the same as the person in the assignment. And if there is none, it will bring up the assignment. And actually it will bring up the assignment regardless of whether it is a task OR an issue, but I think you might just like it better if it’s in two separate reports, so you can group by task name. But truly it’s up to you.

 

The assignment report for the tasks, in the filter area would look like this:

EXISTS:a:$$EXISTSMOD=NOTEXISTS

EXISTS:a:$$OBJCODE=HOUR

EXISTS:a:ownerID=FIELD:assignedToID

taskID_Mod=notblank

 

So the one for issues, would probably look similar like this:

EXISTS:a:$$EXISTSMOD=NOTEXISTS

EXISTS:a:$$OBJCODE=HOUR

EXISTS:a:ownerID=FIELD:assignedToID

opTaskID_Mod=notblank

 

Or if you want them in the same report just do one report and omit the last line.

 

Anyway -- this is all just conjecture but please feel free to test it out and see if it works.

    J
    JD_FCFSAuthor
    February 11, 2026

    Thanks! I actually built this into a Task report, but is there a specific payoff in using an Assignment report instead?  I’m also hitting a snag in trying to make this report dynamic. Here’s what I’ve got now:

     

    assignmentsUsersMM:homeTeamID=$$USER.teamIDs
    assignmentsUsersMM:homeTeamID_Mod=in
    EXISTS:a:$$EXISTSMOD=NOTEXISTS
    EXISTS:a:$$OBJCODE=HOUR
    EXISTS:a:ownerID=FIELD:assignedToID
    EXISTS:a:taskID=FIELD:ID
    status=CPL
    status_Mod=in

     

    So right now it’s showing Tasks where one of the assignees has not logged hours as long as someone with a HomeTeam ID that belongs to a Team I am on is assigned to the task, but I’m getting “false positives” in situations where the person on one of my teams has logged hours, but one of the other assignees on the same task has not. Is there any way to filter out these tasks? I tried adding an AND EXISTS, but maybe I didn’t do it right:

     

    AND:a:EXISTS:a:$$EXISTSMOD=NOTEXISTS
    AND:a:EXISTS:a:$$OBJCODE=HOUR
    AND:a:EXISTS:a:ownerID:homeTeamID=$$USER.teamIDs
    AND:a:EXISTS:a:ownerID:homeTeamID_Mod=in
    AND:a:EXISTS:a:taskID=FIELD:ID

    skyehansen
    Community Advisor and Adobe Champion
    skyehansenCommunity Advisor and Adobe Champion
    February 11, 2026

    ​@JD_FCFS  -- I think in general the problem I’m trying to avoid is that there’s not a good way that I can see, that you can account for multiple assignees in a task report.

    In a task report when I see your exists statement line “EXISTS:a:ownerID=FIELD:assignedToID” all I see is that you’re accounting for the primary task owner -- and not the other assignees. So that’s why i was thinking earlier it would be tough. But that was all conjecture on my part, and if you can get it to work, then more power to you!

    Terms & ConditionsAccessibility statement

    Loading footer...