OQL question: how to join and retrieve User related to owner and changedBy system members

I am struggling to get this to work. For some reason I cannot select the "owner" or "changedBy" members in OQL, or select any references for joining for these members to get to the User entity in the System module. Any help or tips are welcome!
1 answers

After some more experimentation I found out how to do it. You have to use "System.Owner" or "System.changedBy" as the name of the reference when writing the join. Unfortunately this reference is not suggested by the autocomplete popup. It would be nice if it did.


FROM MyFirstModule.TestEntity AS te
INNER JOIN te/System.owner/System.User AS usr