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