Difference between revisions of "Help:Octofy: Visual query builder window"

From Sherlock Software
m
 
Line 1: Line 1:
[[Category: Octofy]]
[[File:Octofy_Query_data_analysis.png|400px|thumb|right|Visual query builder window screenshot]]
 
==Menus==
===File===
{| class="wikitable"
|-
! Menu item !! Description
|-
| Exit || Close the window
|}
 
===Edit===
{| class="wikitable"
|-
! Menu item !! Description !! Shortcut key
|-
| Undo || Undo last step of text edit || Ctrl+Z
|-
| Cut || Cut the selected text in the query text box || Ctrl+X
|-
| Copy || Copy the selected text in the query text box to the clipboard || Ctrl+C
|-
| Paste || Paste the clipboard text to the selection of the text in the query text box || Ctrl+V
|-
| Select all || Select all text in the query text box || Ctrl+A
|}
 
===Analysis===
{| class="wikitable"
|-
! Menu item !! Description !! Shortcut key
|-
| Execute || Read the data by executing the query statement and perform the data analysis || F5
|-
| Parse || Perform the syntax analysis of the query statement || Ctrl+F5
|-
| Preview data || Read the data by executing the query statement and view the data in the preview data window || Ctrl+F6
|}
 
===Tools===
{| class="wikitable"
|-
! Menu item !! Description
|-
| Font || Change the font of the query text box
|}
 
==Toolbar==
{| class="wikitable"
|-
! Tool button !! Description !! Shortcut key
|-
| Analysis || Read the data by executing the query statement and perform the data analysis || F5
|-
| Preview data || Read the data by executing the query statement and view the data in the preview data window || Ctrl+F6
|-
| Parse || Perform the syntax analysis of the query statement || Ctrl+F5
|}
 
----
 
==Database object explorer==
[[File:Octofy_Object_explorer.png|250px|thumb|right|Object explorer]]
[[File:Octofy_Search.png|250px|thumb|right|Object search panel]]
: Database object explorer is located on the left side of the main window. It consists of two tabs:
*Database object navigation tree
: The object navigation tree hierarchy by schema category, base table or view category and, table or view items.
*Search panel
: The search panel is used to search for the tables/views or columns with specific search text.
 
==Visual query builder panel==
A visual edit panel to help build the query statement.
 
==Query text box==
The text box to edit the SQL SELECT statement.


</br>
</br>
----
----
Back to [[Help:Octofy: User Manual|Octofy User Manual]]
Back to [[Help:Octofy: User Manual|Octofy User Manual]]
[[Category: Octofy]]

Latest revision as of 16:12, 5 October 2021

Visual query builder window screenshot

Menus

File

Menu item Description
Exit Close the window

Edit

Menu item Description Shortcut key
Undo Undo last step of text edit Ctrl+Z
Cut Cut the selected text in the query text box Ctrl+X
Copy Copy the selected text in the query text box to the clipboard Ctrl+C
Paste Paste the clipboard text to the selection of the text in the query text box Ctrl+V
Select all Select all text in the query text box Ctrl+A

Analysis

Menu item Description Shortcut key
Execute Read the data by executing the query statement and perform the data analysis F5
Parse Perform the syntax analysis of the query statement Ctrl+F5
Preview data Read the data by executing the query statement and view the data in the preview data window Ctrl+F6

Tools

Menu item Description
Font Change the font of the query text box

Toolbar

Tool button Description Shortcut key
Analysis Read the data by executing the query statement and perform the data analysis F5
Preview data Read the data by executing the query statement and view the data in the preview data window Ctrl+F6
Parse Perform the syntax analysis of the query statement Ctrl+F5

Database object explorer

Object explorer
Object search panel
Database object explorer is located on the left side of the main window. It consists of two tabs:
  • Database object navigation tree
The object navigation tree hierarchy by schema category, base table or view category and, table or view items.
  • Search panel
The search panel is used to search for the tables/views or columns with specific search text.

Visual query builder panel

A visual edit panel to help build the query statement.

Query text box

The text box to edit the SQL SELECT statement.


Back to Octofy User Manual

Retrieved from "https://www.sherlocksoftwareinc.com/wiki/index.php?title=Help:Octofy:_Visual_query_builder_window&oldid=187"