Easily find issues by searching: #<Issue ID>
Easily find members by searching in: <username>, <first name> and <last name>.
Example: Search smith, will return results smith and adamsmith
|Query Builder Workspace Diagram|
|(click here for a keymapping list for the Query Builder)|
|1.||Creates a new Query Builder Document.|
Shortcut Toolbar with Shortcut icon (Orders Table): Shortcut Toolbar is an area for adding Table Entity shortcuts. Once a Shortcut is added here, left clicking it creates a Table Entity with that object's initial properties.
The table shortcut toolbar is a very useful item for people who wish to query the same tables often. You can simply right-click on a table object and select the [add shortcut to toolbar] to add that table's shortcut to the toolbar. Once you have a table shortcut you may right click on that shortcut and change the shortcut properties. For example: if you create many queries on the same tables and wish to always start with them, you could change the properties of their shortcut [Key Binding] to "U" and check the "Clear tables before adding" checkbox. Every time you type U, your current query will be cleared and you will be starting with a new query.
The shortcut toolbar settings are saved even when Query Builder is closed, so your table shortcut toolbar will still have the quick table reference when you re-open the Query Builder.
Opens an existing Query Builder Document.
Loads an existing Query Builder Document (.xqb file) into the Query Builder. If the current database connection of the Query Builder is not that of the document, Query Builder will load the connection information from the document. This is the only method to change database connections in the Query Builder without reloading the Query Builder.
Saves the current Query Builder Document.
After creating a query you may save it as an .xqb file. The file contains local refrence pointer information used by Query Builder to discover database and schema information, but does not actually save any database specific information. So, if you wish to save an .xqb file and reload it on a diffrent computer you will need to make sure that the local reference pointer information is correct. You may do this by opening the file in a text editor and checking it. If you only wish to save the sql statement you may "Save sql as". This will save the sql statement of the object to an .sql file in a text format. You cannot load a .sql file into the Query Builder.
You may also save the result set of the query to file in many diffrent very useful formats. The encoding and platform can be specified or left as default to the current machine but may also be changed if you plan on sending the file to be used by someone in a different country or operating system. The results type can be of the following: Grid Results, Pivot Grid Results, Text Results, Client Statististics or Explain Plan; with the following data formats: HTML, Excel, XML, Insert or Delimited
Explain Plan does not currently process anything within the Query Builder.
|5.||Save As: Saves the current Query Builder Document with options to relocate, rename and change file type.|
|6.||Save SQL as: Saves the current Query Builder Document as an SQL text file.|
|7.||Execute: Runs the SQL statement as created within the SQL pane and displays it to the results pane.|
|8.||Execute Edit: Runs the SQL statement as created within the SQL pane and returns an editable SQL data grid (the Table Data Editor). You may learn more by going to the 12.4 Table Data Editor documentation.|
|9.||Cancel: Will stop an executing sql thread at its current point.|
Group By: Adds/Removes Group By column in the Columns Pane
The Group By column allows the user to give grouping information for columns or to apply data aggregate functions to a column. Data Aggregate functions compute, from a group of rows, a single value for a designated column or expression. This provides the capability to aggregate data, thereby enabling you to perform statistical calculations across many rows with one SQL statement.
|11.||Add Table: Opens the add table dialog.|
|12.||Show Diagram Pane: Shows/Hides the Diagram Pane. The diagram pane holds the visual table objects. Here you can visually add tables and create joins between tables.|
|13.||Show Columns Pane: Shows/Hides the Columns Pane.|
|14.||Show SQL Pane: Shows/Hides the SQL Pane. The sql pane displays the sql statement as it is been created. It is for viewing purposes only, you may not modify the sql statement code through this pane.|
|15.||Show Results Pane: Shows/Hides the Results Pane.|
|16.||Show Datatypes: Shows/Hides Datatypes within the Columns Pane.|
Show Indexes: Shows/Hides the Indexes column in the Columns Pane.
The indexes pane holds the information on all the indexes that are associated to the tables associated to the query being built. On the left side you have the indexes name and parent table with its properties. On the right side you have the columns and sequence to which the index is created.
Indexes are only used when an index's field with leftmost prefix of an index is in the where clause. example:
When scrolling through the indexes, in the columns pane you will see the index and index seq fill with corresponding values. This will help you visualize the sequence of the index to make sure you are taking advantage of the indexes on tables when creating criteria.
Filters: Allows selection of Filters (Quote Identifiers, Fully Qualified Tables, Database Qualified Tables, Auto Join on Foreign Key)
Reconnects to the current database connection if it times out.
Databases can be set up to disconnect idle sessions after an alotted amount of time or the network connection may be lost. This button provides a fast and easy way to attempt to re-establish your connection to the database if you lose your connection for any reason.
|20.||Database: List of Databases on the current Database Server. If "Add New Table" is clicked, the database in this drop-down will be used. It allows the user to change the context of the database, so that the user may select tables and views from different databases.|
|21.||Connection Information: Displays information on the current database connection.|
|22.||Table Entity: When Tables are added to the Query Builder, they appear as Table Entities showing their column information.|
|23.||Max Results: Sets the total number of results displayed from an executed query.|
|24.||JOIN icon: Indicates the "=" type of JOIN.|
|25.||JOIN icon indicating all rows from table "Order Details" selected: This "=" JOIN icon indicates a RIGHT OUTER JOIN.|
|26.||The darker shading on the JOIN indicator highlights it to show that it is currently selected, providing different menu items when right clicked than if it had not been selected.|
Columns Pane: Displays column information on the tables visible in the Diagram Pane.
The column pane is where most of your clauses are created. When you check fields off in the visual tables they will be placed into rows in the column pane. Here you will be able to work with the fields in the query to modify your select statement, where clause, group by clause and order by clause.
|28.||SQL Pane: Displays the formatted SQL of the queries, (read-only text), created by the diagram in the Diagram Pane|
|29.||Indexes Pane (Index Assistant): Shows Index information of the Table Entities from the Diagram Pane.|
|30.||Indexes Pane (Index Assistant - ProductID Index Column Selected): Displays Index of ProductID, with it selected, currently ProductID is listed as sequence 1.|
|31.||Grid Results: This tab displays the results in grid form. Within the Grid Results, charts can be created from the resulting data.|
|32.||Pivot Grid: This tab allows creation of Pivot Grids from the results generated by the script in the SQL Pane. Within the Pivot Grid tab charts of the resulting data can be created.|
|33.||Messages: This tab displays any messages, warnings or errors that appear during query execution.|
|34.||Results Pane: When a query is executed, the results of the query are diplayed here as Grid or Pivot Grid Results with chart creation capability.|
|35.||Results Pane Quick Filter: Following a query execution, the results can be quick filtered to display specific results. The Quick Filter displays results immediately as terms are typed without having to refresh the data.|