Example of a User View Definition

This topic illustrates the use of a user view to retrieve database information on recipients’ travel destination categories.

We first defined a user view called "CategoryDetails". This user view retrieves database records that provide information on recipients’ travel destination categories. The records in this user view include Category Name and Category Picture Name, for each recipient. This information comes from two tables: Customers, which contains the list of recipients and CategoryDetails, which contains the information about the travel destination categories. The following figure illustrates the user view as defined in uPlan.


We also defined the DestName Text ADOR Object and the DestPicture Graphic ADOR Object. As illustrated below, these ADOR Objects call the user view we defined and retrieve the values of the first record in the view.

DestName Text ADOR Object:


DestPicture Graphic ADOR Object: