Text mode proof approval report $$USER.ID

[AbiBeggs]

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

[skyehansen]

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"?

[AbiBeggs]

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]

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