Expand my Community achievements bar.

The Community Advisors application is now OPEN for the second class of 2024. Apply to become a part of this exclusive program!

Report filter for Favorite projects

Avatar

Level 6

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.

7 Comments

Avatar

Level 6

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

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 6

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!