I tried the N-Deep join from https://developer.sugarcrm.com/2014/04/22/sugarcrm-cookbook-sugarquery-the-basics/ but it seems to be not working. did anything changed in Sugar 7.7 $query = new SugarQuery(); $query->from(BeanFactory::getBean('Accounts')…