Skip to main content

SQL View Definition

  1. Last updated
  2. Save as PDF

Define SQL views.

(Parent product) > RADplus Utilities > SQL View Management

  1. Click Select SQL View.

  • The Select A View dialog displays.
  • Click Add New to create a new view.
  • Click Ok.

  1. In the SQL View Schema field, select System.

  2. In the SQL View Name field, enter the view name.

  3. In the SQL View Query field, enter the view query.

SQL view query rules

  • The schema should contain “SYSTEM”

  • The query cannot contain parameters.

  • "SQLUser" is not supported for SQL views

  • The SQL view will be available in the User Definition, and User Role Definition forms (Select Tables For Product SQL Access field).

  • The view can only be modified from the system code where it was defined.

  • If a SQL view is deleted, After deleting, the view will not be available in this form, or in the User Definition, and User Role Definition forms.

SQL view name rules

  • Up to 25 characters long.

  • Must start with a letter

  • Only contain letters, numbers and underscores

  • Cannot end with an underscore, or contain two consecutive underscores

  • Cannot be a SQL reserved word, or contain suffixes used by RADplus.

  • The schema and name together cannot be the same as an existing SQL table, or SQL view.
    This includes:
    System tables and views.
    User modeled tables (Table Definition form).
    User created views (created in this form).