Business Process Parameter Set Data List

Before we can build a page to display and start our food bank inventory business process with a parameter set, we need to provide a feature to display the associated parameter sets.

The data list must support the following requirements:

  1. Ability to uniquely identify the parameter set row within the database. This ID is used to start the business process, edit a parameter set, delete a parameter set, secure a parameter set, and view the status history of the business process. The end user must not be able to see this column within the data list.

  2. Ability to view the name and description of the parameter set.

  3. Ability to view the name of the selection associated with the parameter set.

  4. Ability to view the name of the query view associated with the parameter set.

  5. Ability to uniquely identify the owner (if any) of the parameter set. The end user must not be able to see this column within the data list.

  6. Ability to restrict the view of parameter sets that the current user does not have permission to execute.

To fulfill these requirements the data list requires a SELECT statement to retrieve data from the USR_INVENTORYPROCESS, IDSETREGISTER, BUSINESSPROCESSVIEW, and BUSINESSPROCESSINSTANCEtables.

For more information on these tables, review Tables. The SELECT statement also restricts the view of parameter sets that the current user does not have permission to execute using a user-defined function provided by Blackbaud named UFN_SECURITY_APPUSER_GRANTED_BUSINESSPROCESSINSTANCE_IN_SYSTEMROLE.

The data list returns the following columns of data. Note the hidden columns.

Data List Output Fields

FieldID

Caption

Data Type

IsHidden

Description

ID

System record Id

Guid

True

USR_INVENTORYPROCESS.ID

NAME

Name

String

False

USR_INVENTORYPROCESS.NAME

IDSETREGISTERNAME

Selection

String

False

IDSETREGISTER.NAME

QUERYVIEWCAPTION

Output Format

String

False

BUSINESSPROCESSVIEW.CAPTION

DESCRIPTION

Description

String

False

USR_INVENTORYPROCESS.DESCRIPTION

OWNERID

Owner ID

Guid

True

BUSINESSPROCESSINSTANCE.OWNERID