Expand my Community achievements bar.

The Community Ideas review for H1 2025 is out now, see which ideas our Product team prioritized and let us know your thoughts.

Report filter for Favorite projects

Avatar

Level 7

1/7/22

I would like to be able to create a report that only shows data for projects I have favorited. This list would be dynamic as projects are added and removed from favorites over time.


I don't own my projects, and I'm a resource on some projects that I'm not interested in tracking in detail. My favorites list is the list of projects I would like to appear in some of my reports.

9 Comments

Avatar

Level 7

7/31/24

@Doug_Den_Hoed__AtAppStore , I'm trying to make task reports that only pulls tasks from projects I have favorited.  I believe what you shared shows a list of favorited projects.  Please correct me if I'm wrong.

Avatar

Community Advisor

7/31/24

 

Ah: right you are @ChloeWY,

 

After some experimenting with a couple of very smart colleagues (#tipofmyhat @William-- and @KatherineLa), I invite you to switch your My Favorite Projects Tasks Task filter to textmode and try this:

 

 

EXISTS:1:$$EXISTSMOD=EXISTS
EXISTS:1:$$OBJCODE=FVRITE
EXISTS:1:objID=FIELD:projectID
EXISTS:1:userID=$$USER.ID

 

 

Similarly, this My Subscribed Projects Tasks task filter is returning tasks of projects that the active user is subscribed to, given there is a limit of how many favorites a user can create (as @J_Hobbs was seeking):

 

 

 

EXISTS:1:$$EXISTSMOD=EXISTS
EXISTS:1:$$OBJCODE=SUBSCR
EXISTS:1:projectID=FIELD:projectID
EXISTS:1:subscriberID=$$USER.ID

 

 
*** These above two Task filters are AWESOME, so I encourage everyone who finds this thread to take note and put them to good use! ***
 
@CynthiaBoon, tagging you with an invitation to lift this up among your next Helpful Links update.
 
Regards,
Doug
 

Avatar

Level 7

7/31/24

@Doug_Den_Hoed__AtAppStore This is amazing!! Thank you so much to you and your colleagues!  I can finally use this instead of manually updating my reports every time I add or remove something from my favorites.  Thank you!

Avatar

Level 7

8/14/24

@Doug_Den_Hoed__AtAppStore , just wanted to thank you again for this!  My project load has been changing a lot lately, and having my dashboard automatically update based on which projects I have favorited is so helpful!

Avatar

Community Advisor

8/14/24

 

That is awesome Chloe,


I'm glad it's doing the trick, and yep: this one is a must have for everyone who uses Favorites.

 

Regards,

Doug