Text mode proof approval report $$USER.ID | Community
Skip to main content
A
AbiBeggs
November 12, 2024
Question

Text mode proof approval report $$USER.ID

  • November 12, 2024
  • 1 reply
  • 776 views

Hi all!

I'm working on a proof approval report and want to have it filter for $$USER.ID. I have it working for the document report, using the text mode below. Is anyone able to translate that to work for a proof approval report? 

 

Filtered By:

Exists 1 $$objcode
and Exists 1 ID
and Exists 1 Project Status In CUR
and Exists 2 $$objcode
and Exists 2 Approver ID In $$USER.ID
and Exists 2 documentversionid
and Exists 2 Awaiting Decision Equal (Case Sensitive) true
and Is Current Version Equal (Case Sensitive) true
and Proof Decision Equal pending
This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

1 reply

skyehansen
Community Advisor
skyehansenCommunity Advisor
November 12, 2024

would it be possible to please copy the text mode straight out of the filter section instead of just what shows up in the report when you click "show filter"?

A
AbiBeggsAuthor
November 12, 2024

sure!

 

EXISTS:1:$$OBJCODE=DOCU
EXISTS:1:ID=FIELD:documentID
EXISTS:1:project:status=CUR
EXISTS:1:project:status_Mod=in
EXISTS:2:$$OBJCODE=PRFAPL
EXISTS:2:approverID=$$USER.ID
EXISTS:2:approverID_Mod=in
EXISTS:2:documentVersionID=FIELD:ID
EXISTS:2:isAwaitingDecision=true
EXISTS:2:isAwaitingDecision_Mod=eq
isCurrentVersion=true
isCurrentVersion_Mod=eq
proofDecision=pending
proofDecision_Mod=cieq
proofID_Mod=notblank

skyehansen
Community Advisor
skyehansenCommunity Advisor
November 12, 2024

your previous report was potentially a doc version report... not a document report as you previously stated. In theory, the filter you provided might translate to something like the below, for a proof approval report -- I basically just copied/pasted your code in and adjusted for the different report. I didn't test the code -- so that burden is on you to do.

 

This part is to account for both your first exists statement, and the "current version is true" filter. (I'm trying to only pull in current versions per the second line and re-used the rest of your exists filter, other than that)

 

EXISTS:1:$$OBJCODE=DOCU EXISTS:1:currentVersionID=FIELD:documentVersionID EXISTS:1:project:status=CUR EXISTS:1:project:status_Mod=in

 

 

This next block replaces your second exists filter. I don't think the document version part is needed, since we're only pulling in current versions per the first filter.

 

approverID=$$USER.ID approverID_Mod=in isAwaitingDecision=true isAwaitingDecision_Mod=eq

 

 

This is what the last part of your filter translated to

 

documentVersion:proofDecision=pending documentVersion:proofDecision_Mod=cieq documentVersion:proofID_Mod=notblank

 

 

  

Terms & ConditionsAccessibility statement

Loading footer...