Skip to main content
Version: 4.2

Adding Data Query

You can add data queries based on databases added to supOS under Competence Center > Storage Resources > Resources Management to be used for elements like table, report as data sources in application page design.

info

Only MySQL, Oracle and SQL Server are available for data query.

  1. Click Data Query Management on the left side, and then click New.
    1. Enter the basic information of the data query.
    2. Under Information input, click Add top add input fields for the query script if necessary.
    3. Under Script, click the drop-down list to select a database added to supOS.
    4. Write the query script on the right.
      tip

      Double-click table name or field name on the list on the left side to select them to the script.

    5. Click Debug to check whether the script can run correctly.
  1. After debugging, go back to the data query creation page, click Confirm.