1. Queries into classes with inherited columns

    Article: AN0001881Updated: 08.05.2021

    In case of query that shall use column inherited from a parent class we have to refer to the parent class. In the below example we have class Business-application that is a child of the class All-Applications and inherites column Name.  We want to display names of Business applications and Administrator of the applications.



    Note: Relation in red is created automatically by the system, not by the user. System column ParentDataRowId in the child Business-application is a link the the record in the parent All-Applications.

    SELECT app.name, busapp.administrator FROM {{:class.all-applications:}} app

    INNER JOIN {{:class.business-application:}} busapp ON app.Id = busapp.ParentDataRowId