My Tagged Update Threads by Project | Community
Skip to main content
R
Ryzan99
Level 2
November 6, 2023
Question

My Tagged Update Threads by Project

  • November 6, 2023
  • 2 replies
  • 577 views

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.

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

2 replies

Madalyn_Destafney
Community Advisor
Madalyn_DestafneyCommunity Advisor
Community Advisor
November 6, 2023

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 : )
skyehansen
Community Advisor
skyehansenCommunity Advisor
November 7, 2023

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)

 

Terms & ConditionsAccessibility statement

Loading footer...