Query Canvas

Query Canvas is used to visually layout a query. Query tables and relationships are displayed in this panel.

1. When a query is opened in Query Designer, the Query Canvas panel appears.

Note:
• If the name and/or description is too long to display, ellipses appear at the end of the table name.
• Hover the cursor over the table name to show a tooltip, displaying the full table name and description.
2. See the following table for more information about the available functions in the Query Canvas panel:

Function	Description
Add a Table	Right-click the grey space outside the relationship lines. The Add Tables panel appears, allowing the user to select additional tables.
Move a Table	Click and drag the table header to the desired location.
Resize a Table	Hover the cursor over the border of the table, then click and drag to the desired size.
Create a Relationship	Click a table field, then drag it to the appropriate field in another table.
Modify a Relationship	Double-click on a relationship line, or, select a relationship line, and, right-click (see Create a Relationship for more information).
Select a Field(s)	Double-click the desired field, or, click and drag the field, to add it to the selected fields in the Field List panel. To select multiple fields, select the desired fields, right-click, then select Add to Query, to add the selected fields to the list (see Fields Used Directly from Source Table for more information).