1. Query into the class with a reference to user

    Article: AN0001886Updated:

    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