Help:Octofy: Visual query builder

Query builder and query data analysis windows screenshot

Octofy can perform data analysis on any query data. Query builder and query data analysis window integrates database object browser, search, object data preview, column value frequency check, visual query editor, and query statement syntax check to help users build a SQL SELECT statement. Then use the query statement to get the data from the database and pass the data to the data analysis window for analysis.

Add tables or views

The database object browser and search panel are on the left side of the window. It has the same functions as the database object browser and search panel in the main window. You can use it to find tables or views in the database and add them to the visual query editor on the top right of the window.

Perform data analysis

Back to Octofy User Manual