I have a report built with wildcards that is supposed to show the user any proof requiring their approval. I had someone from my web team create a test proof and assign me to it as a R&A but it doesn't show in the report. I can see it in other reports I use for proof approvals, I got a notification in WF, an email, and it shows in my left side panel in WF home, but not in this proof report and I can't figure out why. I've included all the wildcards I'm using below and I just can't figure out what I'm missing. Anyone have any ideas on what I'm missing?
EXISTS:1:$$OBJCODE=DOCU
EXISTS:1:ID=FIELD:documentID
EXISTS:1:project:status=CUR
EXISTS:1:project:status_Mod=in
EXISTS:2:$$EXISTSMOD=NOTEXISTS
EXISTS:2:$$OBJCODE=PRFAPL
EXISTS:2:approverDecision=approved
EXISTS:2:approverDecision_Mod=cicontains
EXISTS:2:approverID=
EXISTS:2:documentVersionID=FIELD:ID
isCurrentVersion=true
isCurrentVersion_Mod=eq
proofApprovals:approverID=$$USER.ID
proofApprovals:approverID_Mod=eq
proofDecision=Approved
proofDecision_Mod=cine
proofID_Mod=notblank
Views
Replies
Total Likes
you've got a line in there that says "EXISTS:2:approverID=" -- is that intentionally blank or what's usually supposed to go in there?
Views
Replies
Total Likes
That's intentionally blank, didn't know if having my user ID out for everyone to see would be an issue.
Views
Replies
Total Likes
usually not, or you could put in something that just says "my user ID would go in this space" so we know it's not blank in your report.
regardless... I'm not for sure this is the answer but would you consider taking out the notexists line and changing the cicontains to a cine? Just finding it hard to understand exactly what you don't want to exist when you have two things there you're filtering on.
Views
Replies
Total Likes
Views
Likes
Replies