Subquery on aggregate model

Questions
1

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:

2

Checking the console I see the error “cannot have more than one level of relationship”. If Skuid could confirm if my suspicions are correct that I can not more than one relationship level.