1. Query syntax

    Article: AN0001878Updated: 03.10.2018

    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