@Samantha Isin‚ , because a document can consist of many versions pulling in approval decision information from a document report is not going to work. We get to into too many levels of one-to-many relationships (Document can have many versions, each version can have many approvals). So i think to g...
Looks like you must be in a document version report since you reference document in your querysort and valuefield lines (E.g. valuefield=document:project:DE:LIA Section). Unfortunately you cannot sort by a column that has to make 3 jumps. So from a document report, you should be OK because the query...
Nick, you would need to do this through an EXISTS filter. Tony Messam does a great LEAP presentation that discusses what EXISTS filters are. You should go check it out! Anyways, this is the filter that you need. EXISTS:A:$$OBJCODE=TEAMMBEXISTS:A:teamID=$$USER.teamIDsEXISTS:A:userID=FIELD:assignedToI...