Hello - I have a question on some text mode reporting. I want to create a filter that will show users a listing of projects where they have incomplete tasks only.
- Can I set the filter so it runs for whoever is looking at the filter? A $$USER.ID?
- I found this text mode that I wanted to apply, but it doesn't get me the results I am looking for:
EXISTS:A:$$EXISTSMOD=EXISTS
EXISTS:A:$$OBJCODE=TASK
EXISTS:A:actualCompletionDate_Mod=isnull
EXISTS:A:assignmentsUsersMM:ID=61561ca6001b5837b39f802eae6cf25a
EXISTS:A:assignmentsUsersMM:ID_Mod=in
EXISTS:A:projectID=FIELD:ID
status=CUR
status_Mod=in
When I run that, I get projects where the user doesn't have tasks assigned to them at all, but they are listed in the "People" tab. Is there a refinement here I am missing?
Thank you for your help!