Query Flow Tab
You can use the Query Flow tab to create and maintain a stand-alone query. The tab contains the following elements:
Nodes Riser Bar - Displays the nodes that you can add to the Query Flow Editor. The nodes are divided into Clauses and Joins categories. The toolbar above the Nodes Riser Bar enables you to insert a selected node and insert selected nodes before or after nodes that you select in the Query Flow Editor.
Data Connections Riser Bar - Displays the available data connections. You can add the tables listed here to the Query Flow Editor. The toolbar above the Data Connections Riser Bar enables you to insert a selected item and insert tables before a selected node.
Query Flow Editor - Hosts the query flow. You can drop nodes and tables into the Query Flow Editor and manipulate them as needed. The toolbar above the editor provides the following controls:
- Open - Enables you to access the Table View display for a selected table, which includes the Fields, Data Model, DataViewer, and Graph tabs.
- Edit - Enables you to edit a selected object in the Query Flow Editor.
- New Note - Adds a note to the Process Flow Editor.
- Layout - Toggles between Left To Right and Top To Bottom layouts
- Zoom - Zooms into and out of the Process Flow Editor.
- Reset Zoom - Resets the Process Flow Editor to the default level.
SQL Navigation Tree Riser Bar - Displays the SQL components of the current query. You can click the name of a component to open it in a tab.
Data Sample Riser Bar - Displays sample data for a selected field from a table in the Query Flow Editor or the Data Connections Riser Bar. The data displayed does not include null or empty values. It does include duplicate values.
Overview Window - Displays an overview window of the full query flow. You can grab and drag the window to focus on particular segments of the flow.