SBM Item Configuration Details (Sample Request Example)

An example SBM Item configuration, SBM Items from "RLC - Sample Request", is provided for associating RLC - Sample Request items with Release Control requests.

Note: The example configuration requires the RLC - Sample Request process app.

Field Descriptions

The field descriptions are included in the UI. While creating or editing a configuration, point to a field name to view its description.

Some of the available fields for this configuration are defined at the base configuration level. Additional fields are described in the following table.

Field Description Example Values
SBM Table (DBNAME)

Enter the database table name of the SBM table in which you want to submit or transition execution items.

TRM_RLM_BUSINESS_REQ
Project Filter Enter the SBM project in which the items can be actioned, using the internal name without the database table name. For example, for a project named TRM_RLM_BUSINESS_REQ.BUSINESS_REQUESTS, enter BUSINESS_REQUESTS.
Extended Fields

Enter a comma-separated list of fields to populate with data when submitting or transitioning items. See Using Extended Fields to Set Values in Items.

RLM_TASK_OWNER
Query Where Clause

Enter a SQL query where clause to be used to search fields to return the list of possible requests to relate. See the SBM documentation about the GetItemsByQuery call for more information.

TS_PROJECTID=@<PROJECTID> AND (TS_TITLE LIKE N'%@<SEARCHTERMS>%' OR TS_DESCRIPTION LIKE N'%@<SEARCHTERMS>%')
Order By Clause

Enter a SQL statement to order the results of the query. Use this statement to place newest items first in the list or to separate them based on project. See the SBM documentation about the GetItemsByQuery call for more information.

TS_SUBMITDATE ASC

Related Topics

Release Control Administration Overview

Adding Base Configurations

Adding Action and Item Configurations

Updating Plugin Configuration Details