Skip to content
Documentation

View

Views can be registered and called from an action’s SQL function.

Create

  1. Select “Databases” from the side menu and click "Database Name" > "Views" > "Create View".
  2. The editor appears in the right panel.
  3. After describing the contents of the view, click the "Apply" button.
  4. When registration is complete, the view you created will appear in Views.

Sample:

use mydb;
CREATE VIEW joinview AS
select * from t1 left outer join t2 on t1.idf = t2.id2;

Update

  1. Select the view you wish to update by going to Databases > Views > View Name.
  2. The contents of the view are displayed in the editor in the right panel.
  3. Correct the view description.
  4. Click the "Apply" button.

Delete

  1. Select Database > Views > View Name.
  2. Select "Delete" from the context menu.
  3. Click the "OK" button in the "Confirm" dialog box.

Calling

Registered views can be called with the user function SQL Function.

Example of Calling:

select * from joinview;

Data Display

  1. Select Database > Views > View Name.
  2. Click on the "Data" tab.
  3. Displays data (up to 1,000 records) in the view. You can use the "Column Filter" to narrow down the data.

Tips