Project Report filter help please | Community
Skip to main content
ajdifonzo
ajdifonzo
Level 3
August 8, 2023
Solved

Project Report filter help please

  • August 8, 2023
  • 1 reply
  • 621 views

Hi Everyone, 

 

I'm trying to create a project report that will show only projects that are not shared with a specific team.  Here is what I'm trying, but it's not working. 

 

accessRules:accessorID=60d48336000203a147bb42205d4544db
accessRules:accessorID_Mod=cinotcontains

 

Any assistance would be appreciated. 


Alex

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

really nice try, however, exists filters are what you need to utilize in order to report on something which is NOT there (projects which are NOT shared). This ends up looking like:

 

EXISTS:A:$$EXISTSMOD=NOTEXISTS EXISTS:A:$$OBJCODE=ACSRUL EXISTS:A:accessorID=60d48336000203a147bb42205d4544db EXISTS:A:securityObjID=FIELD:ID

 

(this sample code takes into account inherited access as well, so might not be exactly what you were asking above)

 

You can read up more on exists filters here: https://experienceleague.adobe.com/docs/workfront/using/reporting/reports/text-mode/create-complex-text-mode-filters-using-exists-statements.html?lang=en 

 

1 reply

skyehansen
Community Advisor and Adobe Champion
skyehansenCommunity Advisor and Adobe ChampionAccepted solution
August 8, 2023

really nice try, however, exists filters are what you need to utilize in order to report on something which is NOT there (projects which are NOT shared). This ends up looking like:

 

EXISTS:A:$$EXISTSMOD=NOTEXISTS EXISTS:A:$$OBJCODE=ACSRUL EXISTS:A:accessorID=60d48336000203a147bb42205d4544db EXISTS:A:securityObjID=FIELD:ID

 

(this sample code takes into account inherited access as well, so might not be exactly what you were asking above)

 

You can read up more on exists filters here: https://experienceleague.adobe.com/docs/workfront/using/reporting/reports/text-mode/create-complex-text-mode-filters-using-exists-statements.html?lang=en 

 

    ajdifonzo
    ajdifonzoAuthor
    Level 3
    August 8, 2023

    As usual you knocked it out of the park.  Thank you

    And thank you for the link as well. 

      Terms & ConditionsAccessibility statement

      Loading footer...