Skip to main content
MegFl
Level 2
Apr 13, 2023 5:36 PM UTC
Solved

Proof report with project status filter

Is there a way to see current proofs list pending approval on only active (in progress) projects?

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Sheri_WhittenAccepted solution
Community Advisor
Apr 17, 2023 12:52 PM UTC

Yes, but I don't filter for only Active projects because I make a decision of "Acknowledged - Correcting Proof Workflow" on proofs attached to projects that are complete and I make sure the proof email notification goes to the project manager. It's really cut down on how much I have to force close proofs 😉 The textmode I use in my Proof Approval report to see the project status is:

 

displayname=Status
enumclass=com.attask.common.constants.ProjectStatusEnum
enumtype=PROJ
linkedname=documentVersion
namekey=view.relatedcolumn
namekeyargkey.0=documentVersion
namekeyargkey.1=document
namekeyargkey.2=project
namekeyargkey.3=status
querysort=documentVersion:document:project:status
textmode=true
type=enum
valuefield=documentVersion:document:project:status
valueformat=HTML

View in thread

4 replies

EAdams
Level 2
Apr 13, 2023 6:59 PM UTC

I have one that is a document report that shows open projects that have proofs that are waiting a decision and one that shows closed projects that are waiting a decision as well. I like the closed one as then I can clean up proofs. 

It's a document report. This is the filter:

EXISTS:1:$$OBJCODE=DOCV
EXISTS:1:documentID=FIELD:ID
EXISTS:1:proofApprovals:isAwaitingDecision=true
EXISTS:1:proofApprovals:isAwaitingDecision_Mod=eq
currentVersionID_Mod=notblank
project:statusEquatesWith=CUR
project:statusEquatesWith_Mod=in

 

For closed projects you would change the project:statusEquaresWith=CUR to CPL

 

I wish there was a way to see who is reviewing a proof as this only will show approvals. 

Translate
    Lyndsy-Denk
    Adobe Champion and Community Advisor
    Lyndsy-DenkAdobe Champion and Community Advisor
    Adobe Champion and Community Advisor
    Apr 17, 2023 12:17 PM UTC

    Fabulous! Do I infer correctly that, by using DOCV rather than DOCU, this text mode looks at all document versions?

    Translate
    SuryaLakhani
    SuryaLakhani
    Level 4
    Apr 14, 2023 7:38 PM UTC

    Hi,

    If you are using Proof Approval report this should work:

     

    EXISTS:a:$$OBJCODE=DOCU
    EXISTS:a:project:status=CUR
    EXISTS:a:project:status_Mod=in
    EXISTS:a:versions:ID=FIELD:documentVersionID
    isAwaitingDecision=true
    isAwaitingDecision_Mod=eq

    Translate
      Community Advisor
      Sheri_WhittenCommunity AdvisorAccepted solution
      Community Advisor
      Apr 17, 2023 12:52 PM UTC

      Yes, but I don't filter for only Active projects because I make a decision of "Acknowledged - Correcting Proof Workflow" on proofs attached to projects that are complete and I make sure the proof email notification goes to the project manager. It's really cut down on how much I have to force close proofs 😉 The textmode I use in my Proof Approval report to see the project status is:

       

      displayname=Status
      enumclass=com.attask.common.constants.ProjectStatusEnum
      enumtype=PROJ
      linkedname=documentVersion
      namekey=view.relatedcolumn
      namekeyargkey.0=documentVersion
      namekeyargkey.1=document
      namekeyargkey.2=project
      namekeyargkey.3=status
      querysort=documentVersion:document:project:status
      textmode=true
      type=enum
      valuefield=documentVersion:document:project:status
      valueformat=HTML

      Translate
        Terms & ConditionsAccessibility statement

        Loading footer...