User's Guide

Building queries

Index  Next

Active 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 Active 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.

Here are the steps of building an SQL query using Active Query Builder:

• Getting started with Active Query Builder
• Adding an object to the query building area
• Editing object properties
• Joining tables
   
• Selecting output fields
• Sorting output fields
• Defining criterias
• Grouping output fields
   
• Adding a sub-query
• Adding a derived table
• Working with unions
   
• Navigating the query tree

Index  Next