Application Development

Parameter Views

A Parameter View is used to pass environment variables, such as a user ID or a page name. These variables are used in places such as the page title, where ## is substituted for a list where clause or arguments are passed to events.

Refer to Control Views for general information.

Setting up Parameter View involves the following steps:

  1. Create the Parameter View.
  2. Register the Parameter View.

Create the Parameter View

Parameter views are created in SQL Server. Use the following guidelines, which assume basic knowledge of the Stewardship Tier methodology and SQL Server, to create a Parameter View:

  • Use the naming convention web*Evt, where * is a description of the view.
  • Select columns to be used as Event parameters (this is required when the event runs at the row level). These parameters are needed for WebApp events and External events. The view is the page that calls the public event.

Register the Parameter View

To register a Parameter View to a page:

  1. Select Admin > WebApps in the Navigation pane.
  2. Click the Pages icon for the desired WEB APP NAME.
  3. Click Vertical View for the page DESCRIPTION.
  4. Click Control Views tab.
  5. Click Edit.
  6. Select the SQL view from the Parameter View list box.
  7. Click Save.
  8. Click Deprecated Properties tab.
  9. Click Edit.
  10. Select PageTitle from the Horizontal Titlebar list box.
  11. Select PageTitle from the Vertical Titlebar list box.

    NOTE: If the page where the Parameter View is registered does not have a Vertical View, do not edit the Vertical Titlebar.

  1. Click Save.

Example of a Parameter View

In the following example, a Parameter View is used to display the Data Source Name from the previous page (Data Sources) in the Data Source Column Encryption page title. Having a Parameter View assigned to the page is helpful for the user to know which Data Source is being edited.

NOTE: Users are unable to update Stewardship Tier pages; this is strictly an example.

SQL View

Stewardship Tier Page