I am creating a subquery on an aggregate model that has to go through three relationships for the join relationship. (For example I am on object A but I need to pull the ID from Object D.)

I tried hacking the XML with the aggregate alias names but that didn’t work. Can anyone see what I am doing wrong?

I am using this subquery in a filter. The filter works properly on other tables but not this one. The two difference are this is a aggregate model and the subquery goes back so many relationships.

Here is my subquery: