SQL Designer

This wizard allows you to design SQLs by dragging and dropping tables on the Design tab or by typing the complete SQL on the Edit tab. On the Query Object Editor screen, click Properties > Design. The SQL Designer screen appears.

Figure 3: SQL Designer

Note: You can see the schema of database of selected connection for which metadata caching has been done.

Entities are tables from data source and attributes are the columns/fields of that chosen entity i.e. table.

The SQL Designer’s left pane lists Entities and attributes in the selected entity. The area on the right side is divided into the following tabs:

• Design: Use this tab to design relatively simpler queries using drag and drop method. Note: To know more on SQL Designer: Design, please refer “Design” section under Data Preparation > Query Object Data Source > SQL Designer > Design.

• Edit: Use this tab to represent the designed SQL designed as an SQL statement. You can also write or paste SQL here. Note: To know more on SQL Designer: Edit, please refer “Edit” section under Data Preparation > Query Object Data Source > SQL Designer > Edit.

• Result: Use this tab to view the rows received due to SQL execution.Note: To know more on SQL Designer: Result, please refer “Result” section under Data Preparation > Query Object Data Source > SQL Designer > Result.

• Procedure: Use this tab to specify the procedure related details. This tab is brought in front when procedure is selected. Note: To know more on SQL Designer: Procedure, please refer “Procedure” section under Data Preparation > Query Object Data Source > SQL Designer > Procedure.

• Search: Use this tab to search the entities. For example, Branch, Country etc. Note: To know more on Searching The Entities, please refer “ Searching The Entities” section under Data Preparation > Query Object Data Source > SQL Designer > Searching the entities.

Additional tabs namely ‘Sort’ (used to sort preferences) and ‘Filters’ (used to set runtime filter criteria) are available in Web Studio while designing studio reports.

Note: To know more on SQL Designer: Sort, please refer “Sort” section under Data Preparation > Query Object Data Source > SQL Designer > Sort.

Note: To know more on SQL Designer: Filter, please refer “Filter” section under Data Preparation > Query Object Data Source > SQL Designer > Filter.

Getting a list of database objects

The top line indicates the database connection that will be used to get database objects list.

1. Select any of the objects among Table, View, Procedure and Synonym.

2. Entities available on selected connection are listed.  At a time, the list displays a pre-set number of entities. If the entity you are looking for is not available in the list, use the drop-down box options to view another set of entities. To get next list, click Next link. To get previous list, click Prev link.

When you refresh the screen, the date and time when the refresh occurred appears on the top of the SQL Designer.