Using the Query Designer to Create Queries

Use the Query Designer to generate select statements inside queries, lookup definitions, preprocessing and postprocessing SQL statements.

• Opening the Query Designer
  Use the Demo Getting Started project from the Demo Repository to create queries using the Query Designer.
• Creating a Simple Query
  To generate a simple query that retrieves all attributes from a table, use the PRODUCTS table, available in the demo Getting Started project within the Demo Repository.
• Creating a Query Using Multiple Tables
  To generate a query that joins and retrieves information from two tables, use the PRODUCTS and SALES tables.
• Modifying the Default Settings of a Join
  A join between two tables is indicated by a line that connects the joining fields. The line is labeled with a join operator, which, by default, is called equijoin.
• Modifying the Sort Order of Joins
  Edit the sort order of joins.
• Adding One or More Attributes to the Select Clause
  Update the select clause to add one or more attributes.
• Adding All Attributes of a Selected Table to the Select Clause
  Update the select clause to add all attributes of a selected table.
• Viewing Attribute Details and Generated Query
  See the query generated by the Query Designer along with the attribute details.
• Adding Functions to the Select Attribute
  Update the select attribute to add functions.
• Adding Alias Names to Selected Attributes
  Include alias names for attributes.