Query Builder

<< Click to Display Table of Contents >>

Navigation:  User Interface Reference >

Query Builder

Previous pageReturn to chapter overviewNext page

 

 

Plato Analysis Query Builder is a visual query builder component that allows you to build complex SQL queries via an intuitive visual query building interface.

 

To work with the Plato Analysis Query Builder, you need basic knowledge of SQL concepts. Active Query Builder will help you to write correct SQL code hiding technical details, but only understanding of the SQL principles will make it possible to achieve desired results.

 

The Plato Analysis Query Builder allows for building complex SQL queries visually:

 

- Build queries with different join types

 

- Build queries with sorting, grouping and complex criteria.

 

- Build queries with different server-specific options.