No problem!
So in your example, you are "moving up the hierarchy" to QUED (aka Referencing). So on the OBJCODE QUED, you look at the ID field and that equals queueDefID on the current object
For the Milestone information, you are "moving down the hierarchy" to Tasks. So on the OBJCODE TASK, we need a field that is the same as on our current object (Projects). So that is why we have projectID first and say that equals the ID on the project.
Hope that makes sense. Below is the cheat sheet that I have in One Notes to help me out (It is from a LEAP session with the amazing Jason Webre and Tony Messum)
Moving Up The Hierarchy
This is for reports where you want to jump up more than one level. (Like show me projects where the portfolio owner is no longer active)
EXISTS:1:$$OBJCODE=[Insert the Object Code for Reference]
EXISTS:1:[Reference Object Type's field that matches current object]=FIELD:[Current Object Type's field that matches reference object]
EXISTS:1:[Field on Reference being filtered]=[Condition]
Based on my Example:
EXISTS:1:$$OBJCODE=PORT
EXISTS:1:ID=FIELD:portfolioID
EXISTS:1:owner:isActive=False
Moving Down The Hierarchy
This is for reports where you want to apply a filter based on a many-to-one relationship (Like portfolios that have projects Anthony owns)
EXISTS:1:$$OBJCODE=[Insert Object Code for the Collection]
EXISTS:1:[Collection Object Type's field that matches current object]=FIELD:[Current Object Type's field that matches collection object]
EXISTS:1:[Field on Collection being filtered]=[Condition]
Based on my Example:
EXISTS:1:$$OBJCODE=PROJ
EXISTS:1:portfolioID=FIELD:ID
EXISTS:1:ownerID=532376910024d8443277c3e46ed5330a
Showing Items Not Selected
This is for reports where you want to show items where a multiple-select option is NOT selected (Like projects that are not Digital)
EXISTS:1:$$OBJCODE=[Current Object Code]
EXISTS:1:ID=FIELD=ID
EXISTS:1:[Custom Field You Are Filtering On]=[What the TRUE expression would be]
EXISTS:1:$$EXISTSMOD=NOTEXISTS
Based on my Example:
EXISTS:1:$$OBJCODE=PROJ
EXISTS:1:ID=FIELD=ID
EXISTS:1:DE:Type of Project=Digital
EXISTS:1:$$EXISTSMOD=NOTEXISTS
