1. Query syntax

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

    Query represents set of records selected from specified classes and processed according to specified criteria. Each query belongs to a certain model. However, within query one can refer also to classes from other models. Queries are defined in ObjectGears in the same way like SQL queries in MS SQL Server which provides necessary flexibility. Since we refer to the defined classes and not to a physical data store (database), queries in ObjectGears have several specifics.

     

    Example of simple query creation

    Example of query with reference to user

    Example of query with multiple references

    Example of query with inherited columns

×