Using the Field List for Custom Columns

When you specify ServiceNow table fields in the Field List properties in a ServiceNow plugin configuration, the plugin stores this data in the Release Control tables. You can then use these fields in the custom column entries so that you can display any ServiceNow table data in the Release Control ServiceNow request fields.

To add columns from ServiceNow tables:

1. In the Release Control Providers administrator page, update the ServiceNow plugin configuration as follows:
   1. In Tables, enter one or more ServiceNow tables from which you want to display data in Release Control.

      For example:

      problem:Problem

   2. Add Title, Name, and Description mappings for the table. For example:

      Title: problem:number

      Name: problem:short_description

      Description: problem:description

      If you don't specify these, Title, Name, and Description columns in the Request widget will be empty by default.

      Any custom value defined in Field List can also be used for these fields.

   3. In Field List, enter one or more fields that you want to display from the tables you entered in the Tables field.

      For example:

      work_notes:DATETIME,priority

      You don't need to specify any of the following, as they are available by default: sys_id, number, description, short_description, sys_created_by, sys_created_on, sys_updated_by, sys_updated_on, assigned_to

   4. You can also extend search terms by entering a ServiceNow table query in the Query field.

      For example:

      short_description LIKE {SEARCHTERMS} ^ OR description LIKE{SEARCHTERMS} ^ OR priority LIKE {SEARCHTERMS}

2. In SBM Application Administrator, do the following:
   1. In Auxiliary Data, select the RLC Custom Columns auxiliary table.
   2. Update the entry you are using for your request columns, such as Default Requests Custom Columns.
   3. In Internal Names, add the database internal names for the ServiceNow table fields, such as the following:

      title, name, description, sys_created_by, sys_created_on, sys_updated_by, sys_updated_on, assigned_to, work_notes, priority

   4. In Display Names, add the database display names you want to appear in the request column, such as the following:

      Title, Name, Description, Created By, Created On, Updated By, Updated On, Assigned To, Work Notes, Priority