Defining User Views

User Views enable you to retrieve several fields at once from the database using a single SQL query, rather than retrieving each field, one at a time. Generally, the resulting view is a table with multiple columns and rows for each recipient. It can be used to define Table ADOR objects or other types of ADOR Objects. For example, a user view may display the last 10 purchases made by a customer.

If you use the Wizard to create your Plan, uPlan automatically creates user views.

When you right-click the User Views icon, the following menu options are displayed:

Option

Description

New User View

Create a new untitled user view.

New Group

Create a new group of user views.

Expand/Collapse All Groups

Expand or collapse all groups so you can see or hide their contents.

Paste

Paste a previously cut or copied user view, table, or recipient information schema into the list of user views.

Order User Views

Sort the user views by name.

When you right-click a specific user view group, the following menu options are displayed:

Option

Description

New User View

Create a new user view in the current group.

Rename

Rename the current user view group.

Paste

Paste a previously copied user view into the current group.

Delete

Delete the currently selected group, provided it is empty.

Order User Views

Sort the user views inside the group, by name.

When you right-click a specific user view, the following menu options aer displayed:

Option

Description

New Field

Add a new field to the currently selected user view. This field must be included in the SQL query you use to retrieve information for the current user view.

Edit Expression

Edit the user view’s expression in an Expression window.

Insert

Insert the currently selected user view into the active Expression window.

Create Table ADOR

Create a Table ADOR Object from the currently selected user view.

Rename

Rename the currently selected user view.

Move to Group

Move the user view into the selected group.

Cut, Copy, Paste, Delete, Duplicate

Cut, copy, paste, delete, or duplicate the currently selected user view.

Order Fields

Sort the fields in the currently selected user view by name or type.

When you right-click a specific field in a user view, the following menu options are displayed:

Option

Description

Insert

Insert the currently selected field into the active Expression window.

Rename

Rename the currently selected field in the user view.

Type

Define the type of field in the user view: Bool, Date, Number, or String.

Cut, Copy, Delete, Duplicate

Cut, copy, delete, or duplicate the currently selected field in the user view.

See Also

Example of a User View Definition

Defining a User View from an XML String