Expand my Community achievements bar.

The next phase for Workfront Community ideas is coming soon. Learn all about it in our blog!

My Tagged Update Threads by Project

Avatar

Level 2

Hello Workfront Community,

I'm trying to build a report to show updates where I've been tagged in various projects. I tried to follow the steps from this cookbook on pages 19 - 21, https://cdn.experience.workfront.com/One/Files/2021.07+Reporting+cookbook_final.pdf.

Request:
I want to exclude comments/updates that were posted by me. How can I do that? Please advise.

Thank you.

2 Replies

Avatar

Community Advisor

I have a Note report to show updates I've been tagged in past 5 days that some of our users use, pulls $$USER.ID and of course you can change the timeframe. Grouped by project. 
Grouping:
textmode=true
group.0.namekeyargkey.0=project
group.0.namekeyargkey.1=name
group.0.valuefield=project:name
group.0.iscollapsed=true
group.0.valueformat=string
group.0.linkedname=project
group.0.name=

Filters:
EXISTS:a:$$EXISTSMOD=EXISTS
EXISTS:a:$$OBJCODE=NTAG
EXISTS:a:noteID=FIELD:ID
EXISTS:a:teamID=$$USER.teamIDs
EXISTS:a:teamID_Mod=contains
OR:1:EXISTS:a:$$EXISTSMOD=EXISTS
OR:1:EXISTS:a:$$OBJCODE=NTAG
OR:1:EXISTS:a:noteID=FIELD:ID
OR:1:EXISTS:a:userID=$$USER.ID
OR:1:entryDate=$$NOW-5d
OR:1:entryDate_Mod=between
OR:1:entryDate_Range=$$NOW
entryDate=$$NOW-5d
entryDate_Mod=between
entryDate_Range=$$NOW

If you found this helpful, please mark correct to help others : )

If this helped you, please mark correct to help others : )

Avatar

Level 3

hi, this is a Note report.

The person who posts the comment/update is known as the "owner" of the note. You would normally exclude this in a normal note report by selecting "Note | Owner ID is blank" while in standard mode.

 

When you convert to text mode -- like you did here -- you can easily recover by temporarily starting a new note report. Set up this additional filter in that temporary report, then switch over to text mode to convert this additional filter to text mode. Finally, go back to your current report to copy/paste the additional filter into your current text mode. (You can discard the temporary report.)

 

The additional filter should have looked something like this (if it doesn't, just come back and paste your screenshot so we can see where you went wrong)

 

ownerID=$$USER.ID
ownerID_Mod=notin

 

In the case of the cookbook filter you mentioned, there's only one set of filters, so you can copy the lines right into it (anywhere in the filter section).

 

If you added any additional filter SETS (any repeating lines that are prefaced with "OR:") you would have to add the additional filter to all your "OR" sets as well. (hopefully that made sense, if not just post your code and I'm sure someone will help you fix it)