Skip to main content
ChloeWY
ChloeWY
Level 6
January 7, 2022
New

Report filter for Favorite projects

  • January 7, 2022
  • 9 replies
  • 1199 views

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 replies

    J
    J_Hobbs
    Level 3
    March 29, 2022

    I could see this being done for "Recents" as well.


    I personally use that way more than Favorites.

    Doug_Den_Hoed_AtAppStore
    Community Advisor
    Doug_Den_Hoed_AtAppStoreCommunity Advisor
    Community Advisor
    July 31, 2024

     

    Hi @chloewy,

     

    I invite you to roll your own My Favorite Projects filter as below.

     

    Regards,

    Doug

     

     

     

     

    ChloeWY
    ChloeWYAuthor
    Level 6
    July 31, 2024

    @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.

    Doug_Den_Hoed_AtAppStore
    Community Advisor
    Doug_Den_Hoed_AtAppStoreCommunity Advisor
    Community Advisor
    July 31, 2024

     

    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
     
    ChloeWY
    ChloeWYAuthor
    Level 6
    July 31, 2024

    @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!

    Doug_Den_Hoed_AtAppStore
    Community Advisor
    Doug_Den_Hoed_AtAppStoreCommunity Advisor
    Community Advisor
    July 31, 2024

     

    I agree @chloewy -- thanks for the excellent challenge, and enjoy!

     

    Regards,

    Doug

    CynthiaBoon
    Adobe Employee
    CynthiaBoonAdobe Employee
    Adobe Employee
    August 2, 2024

    Thank you both! Adding it to this month's Hot Topics post!

    ChloeWY
    ChloeWYAuthor
    Level 6
    August 14, 2024

    @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!

    Doug_Den_Hoed_AtAppStore
    Community Advisor
    Doug_Den_Hoed_AtAppStoreCommunity Advisor
    Community Advisor
    August 15, 2024

     

    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

    Terms & ConditionsAccessibility statement

    Loading footer...