Web System Common Tools

Web System Applications Development

 Web System Database Web System PostgreSQL Tables Web System Manage fields Web System Manage constraints Web System Manage indexes Web System Manage triggers Web System SQL Tab Web System Single-row editing Web System Multirow editing in table mode Web System Import Web System Export Web System Table transfer - or Store Web System Composite Types Web System SQL Queries Web System Workflow Web System Dataset Design Web System Query Expressions Web System Where Conditions Web System Group by Expressions Web System Having Condition Web System Windows Clause Web System Order by Expressions Web System SQL Tab Web System Test a Query Web System Views Web System Functions Web System Datasources Web System Charts Web System Main type selection Web System Subtype selection Web System Datasource selection Web System General settings Web System Axis settings Web System Background settings Web System Margin settings Web System Color settings Web System Mark settings Web System QR Barcodes Web System Saving Web System Reports Web System Template Editor GYRE Web System Sections Web System Toolbar Web System Basic properties Web System Data formatting Web System Text Web System Data Web System Macro Web System Geometry Web System Line Web System Bezier curve Web System Image Web System Chart Web System Arrangement Web System Clipboard Web System History Web System Zoom Web System Import/export Web System Delete Web System Report Generator Web System Report Schedule Web Site Builder Web System Content Management System (CMS) Web System Edit site Web System Themes and pages Web System Create and edit theme Web System Edit page Web System Web Form Builder / Content Editor (GYRE) Web System Toolbar Web System Events Web System Basic properties Web System Text field Web System Button Web System List Web System Combobox Web System Label Web System Checkbox Web System Radiobutton Web System Filler Web System Upload file Web System Additional tools (Gears) Web System Image Web System Flash video Web System Arrangement Web System Clipboard Web System History Web System Zoom Web System Import/export Web System Delete Web System Operations with objects Web System DNS Manager Web System SEO tools Web System App Analyzer Web System Reindex Web System Publish Web System Access Log Web System Checkout settings Web System PHP Scripts development (Actions) Web System Source Editor Web System API functions Web System Custom Scripts development (JS, CSS, XML, etc...) Web System Gears Web System SaaS Solution Manager

Web System Cook book

Web System Deprecated

Web System Views

Web System Views are SQL queries (see Web System SQL Queries) saved in the databse. They can be used in other queries, along with tables (unlike queries, views are database objects). It is not uncommon to create views based on other views.

Creating views is one of the key aspects of quality database design. Views encapsulate the details of table structures, which may change during the development process.

SQL Views list

A View in Younicycle is created by selecting a specific Query(seeWeb System SQL Queries).

Name - Name of the future View. The name of the View cannot be the same as the names of tables or any other Views in the database (regardless of the folder in which they are saved). This limitation is based on a PostgreSQL requirement.
Description - View description. Information field for database developers.
Folder - Folder in which a View will be saved.
Select query - select a query, the basis on which a View is created.

When you click the View tab, you will see the output of the View and the Dependency for that View.  You can move (reorganize) your View to a different folder from this tab. 

View cpu_i7_8 is part of  FROM clause just like regular tables.  You may find it helful to name your Views with 'v_' to aid in identifying Views as opposed to Tables.  'v_cpu_i7_8', as an example. 

Your list of Views will appear in the Dataset Design tab of the Query Builder - below your list of Tables. 
A View is treated by PostgreSQL as a type of Temporary Table.

Shown below is the SQL Tab of the Query Builder, for a specific Query - which includes a View. 

You can always Test your Query by clicking the Refresh button in the Test Query Tab of the Query Builder. 
You can test before you save, allowing immediate feedback.

As with Tables, you can Export the data from a View as CSV, XML or Excel by clicking the Export tab.  Shown below is the Export interface.



File type - Picks the file type data would be exported to: CSV (comma separated values), XML, or MS Excel table.
Separate character - Column separator. Available only when exporting to CSV.
Fields order - Sets the column order in the exported file.

Note: "file" columns can't be exported.