Optionally Create a Selection of Processed Records with the CreateIDSet() Function

The CreateIDSet()function creates a selection which contains the IDs of the records processed for a particular record type. CreateIDSet() function supports the "Create selection of processed records" option found on most business process definitions. A selection can be used as an input into a business process or created by a business process. 

Selections can also be created using Blackbaud's query tool by first creating either 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."  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 used as 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 Transact-SQL JOIN or WHERE clause. 

If you are unfamiliar with queries or selections, check out the Query and Export Guide.