Retrieve Users that are system owners of my entity?

0
Hi. There's System.FileDocument with system owner enabled. With XPath I can retrieve System.FileDocument and filter by [System.owner/System.User], but I can't retrieve System.User and filter by [System.owner/System.FileDocument]. It gives syntax error:   1    2    Cannot reach entity 'System.FileDocument' from entity 'System.User' using cross-module association 'System.owner'.   What if I need to know users that own certain objects?   Is this a bug? I was unable to find this in the documentation.  
asked
1 answers
0

If you start in System.User, it has multiple owner-tables to all entities where the system member owner is saved. It's like a crossroads where the database doesn't  know which road to take.

 

You can do it using OQL though:

SELECT DISTINCT u/id
FROM System.FileDocument f
INNER JOIN f/System.owner/System.User u

 

answered