Advanced server support for complex data needs.

Advanced server support for complex data needs.

Available with Power version and above.

Advanced Search and Aggregation: Complex searches assembled via the FilterBuilder component can be executed against SQL, JPA, or Hibernate without the need to write any code.

Declarative aggregation allows server-side grouping and summarization to be performed, including defining DataSource fields as aggregations of data in related DataSources.

SQL/HQL Templating: Allows the SQL or HQL queries automatically generated by the SQL and Hibernate connectors to be easily customized directly in the DataSource definition, by overriding specific clauses from the automatically generated query, without the need to write Java code.

SQL Templating makes it trivial to use SQL joins while retaining built-in features like advanced search. Even complex reporting queries can still leverage search, data paging, and other built-in features.