ObjectGears Help

Forum   ObjectGears (Version:

Query into the class with a reference to user

In case of reference to a user it is necessary to work with the table person. We have to refer to it with a simple stating its name (without double brackets and colon as in case of classes defined by user).



Note: Entity person highlighted in red is the system table containing ObjectGears users. It is not created by the user.

SELECT p.id AS Project_ID, p.code, per.code AS PERSON

FROM {{: class.project :}} p

INNER JOIN person per ON per.id = p.person

This website is using cookies files to provide services and analyse visits. You agree with that by using this website.     Further information