Filtering, linking entities, aggregation and grouping

With the query language, the developer and also the user can safely retrieve data from ONE Framework. Each query is passed through the security system so that the user executing the query can see only the data he has access to.

Filtering

Filtering can be done using operators (equals, not equals, greater than, less than, like, etc.) and multiple conditions can be grouped using AND or OR operators to form complex expressions.

Linking entities

Linking (same as JOIN in SQL semantics) can be used to walk through relationships, creating complex results with data from many entities.

Aggregation and Grouping

Aggregation and grouping helps the user retrieve calculated data from entities such as SUM, AVG, STD etc.