|
Home > Our Products > Digital Gridworks™ Studio > Documentation > Querying Data From The Connection Tree
|
| |
Querying Data From The Connection TreeOnce you have successfully opened a connection, the tree will populate with databases. Right click on a database (or an object that is a child) to activatethe context menu. You will find that you can now invoke the Visual Query Builder,a new SQL Editor window, or issue a generated, recent or favorite SQL statement. Visual Query BuilderThe Visual Query Builder is a simple form that allows you to choose the tables and views you wish to select from, the types of JOINS to perform, and the criteria andoutput of the query. There are extra attributes that you can edit under the Attributestab. The SQL Preview tab will give you a preview of the generated SQL statement. Once you are content with the query, you can press Okay. This will insert the newSQL statement into a SQL Editor form ready for execution. Select * / Top / Limit / OffsetThe connection tree context menu provides a utility to quickly build basic SQL statements.These options are only available if you right click on a table or view. You can select all rows and columns (*), or a limited set (TOP, LIMIT, OFFSET). The database grammar dictateswhich limiting syntax to use (either TOP or LIMIT/OFFSET).Recent and Favorite QueriesAs you run SQL statements in the SQL Editor form, they are inserted into a global list calledthe Recent Queries list. This list contains the most recently run queries and is preserved across application shutdowns. You can also insert queries into the Favorite Queries list and access them from the context menu. To manage the lists, open a SQL Editor formand choose Scripts > Manage Favorite/Recent SQL Query Lists. |
|
|
|
