ObjectGears Help

           
Forum   ObjectGears (Version: 1.6.0.0)

Queries into classes with inherited columns

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 ParentId 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

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