1. Queries into classes with inherited columns

    Artikel: AN0001881Aktualisiert: 08.05.2021
    Die vorgegebene Sprachenversion vom Artikeltext wird angezeigt, weil es kein Text von der ausgewählten Sprache und Version gibt.

    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

×