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