Select your user interface: Web Shell Smart Client

IDSETREGISTERID Field References the IDSETREGISTER Table

The IDSETREGISTER table contains a list of selections used throughout the system. Often business processes require a reference to what's a known as a selection, which is a set of record IDs for a particular record type. Selections can be created using Blackbaud's query tool by first creating an ad-hoc query or smart query and then saving the query results as a selection. A selection may be created by other business processes as some processes employ an option to "Create selection of processed records." A selection contains the IDs of the records to use as input into and be processed by a business process in order to restrict the number of rows processed.

Within the food bank inventory business process, the IDSETREGISTERID field points to a system table named IDSETREGISTER. Each row in the IDSETREGISTER table corresponds to a view or table-valued function that returns a list of Primary Key ID values of a particular record type (database table), such as Constituent or Revenue.

Note: Selections can be created via Blackbaud's query tool. A selection can be an input parameter into a business process instance. A selection is a list of record IDs used within the business process .NET code to restrict the number of rows processed by a SQL JOIN or WHERE clause. 

if you are unfamiliar with query and selections, check out the Query and Export Guide.

For an example of how a selection is used as a parameter within a parameter set for a business process, let's take a look at a data form that is used to manage a parameter set.  Within the Food Bank's Inventory Process Business Process Add and Edit Forms, you can choose the selection to use as an input parameter into the business process. After it is saved, the data from these data forms is saved to a row USR_INVENTORYPROCESS table.

Figure: The Inventory Process Business Process Edit Form edits a parameter set for the food bank inventory business process.

Before you start a business process, a row must be selected from this table to provide the business process with the necessary input parameter data. 

Figure: Select a parameter set before you start a business process.