Hi all, mental block here - I have an hour report for all active users grouped by user so I can see total hours logged by user, but what this wouldn't pull is any user that has ZERO logged time (ever, on any object). How can I pull this?
Hi Madalyn,
I have to give credit to @doug_den_hoed__atappstore for this one that I have saved. This is not an hour report, but a user report with the following to that will return any Users with no hours entered in the past 7 days (for example):
EXISTS:a:$$EXISTSMOD=NOTEXISTS
EXISTS:a:$$OBJCODE=HOUR
EXISTS:a:entryDate=$$TODAY-7d
EXISTS:a:entryDate_Mod=gt
EXISTS:a:ownerID=FIELD:ID
Hope this helps.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.