Query Builder

With Query Builder you can create reports without having to know SQL syntax or the names of columns and constants. The Query Builder knows the columns and its data types for a view, so you don’t have to remember how they are spelled or how to format dates and numbers or what available static codes a column can have. It also knows how many of the views are related to each other, making it really easy to join those views, i.e. you don’t have to remember which columns maps to each other.

Read more on how to use the Query Builder in the Administration Guide