Join a related object its related object?

I’m just trying to figure out if this is possible. As I’m getting no results (while there’s at least one) I’m guessing the way I’m trying it aint gonna work.

Basically I have a table which holds some extra user data specific to my application, which holds a one-one relation to the modUser object.

Now the modUser object has a one-one relation to modUserProfile and I’m trying to join that one into the table as well. This gives me no results:

(where $c is a newQuery(MyObject))

Is it possible to join a joined table?

A workaround I just thought of while writing this is creating another alias "UserProfile" in my component object that directly hooks into the modUserProfile object. While that would work for my case (as the modUserProfile uses the modUser ID which is stored in my table too), I can imagine some use cases where a certain value is not found in the component object and this would still be a valid question..

I’m not sure if this will help, but it may: http://www.shawnwilkerson.com/xpdo/using-xpdo-across-tables/xpdo-newquery-innerjoin.html

Thanks, but that isn’t exactly what I’m doing... Those innerJoin calls Shawn uses there are all "at the same level":

Zip
- State
- Country
- Timezone

While I’m going in deeper...

Contributor (my own table)
- modUser (relation alias "User")
-- modUserProfile (relation alias "Profile" iirc)

I could use something like getCollectionGraph(’Contributor’,’{ "User": { "Profile": {} } }’) - but as I’m joining the tables to only select a couple of fields I think performance wise that would be faster if possible?

.. why didn’t I think of that?

Once again, MODX saves the day.


Thanks Shaun!