The CIRelatedList script include is a utility class that provides methods for working with configuration item (CI) related lists.

Each instance of this script include contains the details of a single list that is related to a particular CI. The details of this list and the contents of the list are included.

Use with any server-side discovery script.

CIRelatedList - addRec(Object record)

Adds the specified record to the related list.

Table 1. Parameters
Name Type Description
record Object Each member in the object is a column name in the associated table. For example, if referencing the cmdb_serial_number table this value may contain something similar to the following:

{"serial_number_type":"bios","serial_number":"1BC5E4z89246","valid":"true"}
Table 2. Returns
Type Description
void

Example

This example shows how to add a record to a CI related list.

var ciDataObj = new CIData(); // Instantiate a new CIData class object

// sys_id of the CI to which the related list is attached.
var rl = new CIRelatedList('cmdb_serial_number', 'cmdb_ci','0c43b0f5c6112275019abd2bb3dcd78f','true');

// Create an object and add the serial numbers
var sr = {"serial_number_type":"bios","serial_number":"1BC5E4z89246","valid":"true"};
rl.addRec(sr); // Add the related list. Sets the given records to the related list.
ciDataObj.addRelatedList(rl); // Adding the related list to the cidata
gs.info(JSON.stringify(rl, null, 4)); // Display the added related list

Output:

{
  "GlideRecordUtil": {},
  "ignoreFields": {
    "sys_created_by": true,
    "sys_updated_by": true,
    "sys_mod_count": true
  },
  "records": [
    {
      "serial_number_type": "bios",
      "serial_number": "1BC5E4z89246",
      "valid": "true"
    }
  ],
  "m2m_records": [],
  "table_name": "cmdb_serial_number",
  "field_name": "cmdb_ci",
  "cmdb_ci": "0c43b0f5c6112275019abd2bb3dcd78f",
  "debug_flag": "true",
  "isM2M": false,
  "target_table_name": null,
  "target_ref_field_name": null
}

CIRelatedList - addRecs(Array records)

Sets the given records to the related list.

Table 3. Parameters
Name Type Description
records Array of Objects Each object represents a record in the associated table. Each member in the object is a column name in that table. For example, if referencing the cmdb_serial_number table this value may contain something similar to the following:

[{"serial_number_type":"bios","serial_number":"1BC5E4z89246","valid":"true"},{"serial_number_type":"baseboard","serial_number":"w4z89246","valid":"true"}]
Table 4. Returns
Type Description
void

Example

This example shows how to add multiple records to a CI related list.

var ciDataObj = new CIData(); // Instantiate a new CIData class object

// sys_id of the CI to which the related list is attached.
var rl = new CIRelatedList('cmdb_serial_number', 'cmdb_ci','0c43b0f5c6112275019abd2bb3dcd78f','true');

// Create an object and add the serial numbers
var sr = [{"serial_number_type":"bios","serial_number":"1BC5E4z89246","valid":"true"},{"serial_number_type":"baseboard","serial_number":"w4z89246","valid":"true"}];

rl.addRecs(sr); // Add the related list. Sets the given records to the related list.

ciDataObj.addRelatedList(rl); // Adding the related list to the cidata
gs.info(JSON.stringify(rl, null, 4)); // Display the added related list

Output:

{
  "GlideRecordUtil": {},
  "ignoreFields": {
    "sys_created_by": true,
    "sys_updated_by": true,
    "sys_mod_count": true
  },
  "records": [
    {
      "serial_number_type": "bios",
      "serial_number": "1BC5E4z89246",
      "valid": "true"
    },
    {
      "serial_number_type": "baseboard",
      "serial_number": "w4z89246",
      "valid": "true"
    }
  ],
  "m2m_records": [],
  "table_name": "cmdb_serial_number",
  "field_name": "cmdb_ci",
  "cmdb_ci": "0c43b0f5c6112275019abd2bb3dcd78f",
  "debug_flag": "true",
  "isM2M": false,
  "target_table_name": null,
  "target_ref_field_name": null
}

CIRelatedList - appendXMLChildFld(String parent, String name, String datum)

Appends an XML child to a field.

Table 5. Parameters
Name Type Description
parent String The parent element
name String The element name
datum String The data to append
Table 6. Returns
Type Description
void

CIRelatedList - appendXMLChildRecord(String parent, String name, String record)

Appends an XML child to a record.

Table 7. Parameters
Name Type Description
parent String The parent element
name String The element name
record String The record
Table 8. Returns
Type Description
void

CIRelatedList - checkSysCollection()

Checks to see if this is a SysCollection table. If it is, sets the target table name and reference field name.

Table 9. Parameters
Name Type Description
None
Table 10. Returns
Type Description
CIRelatedList An instance of CIRelatedList for the specified list.

CIRelatedList - checkSysM2M()

Checks to see if this is a Sys many-to-many table. If it is, sets the target table name and reference field name.

Table 11. Parameters
Name Type Description
None
Table 12. Returns
Type Description
Boolean True if it is a sys many-to-many table; otherwise, false.

CIRelatedList - CIRelatedList(String table, String refField, String cmdb_ci, String debugFlag)

Creates an instance of the CIRelatedList class. With no arguments, simply constructs an empty instance.

Table 13. Parameters
NameTypeDescription
table String The table containing the related list. If many-to-many, the many-to-many table.
refField String The reference field in the table for this related list.
cmdb_ci String The sys_id of the CI this list is related to.
debugFlag String If true, debug logging is enabled.

CIRelatedList - fromXML(String element)

Initializes this instance from the specified XML element.

Table 14. Parameters
Name Type Description
element String An XML element
Table 15. Returns
Type Description
void

CIRelatedList - populate()

Populates the this.records field of this instance.

Table 16. Parameters
Name Type Description
None
Table 17. Returns
Type Description
void

CIRelatedList - toString(Array result)

Makes a string representation of this instance, pushing each line onto the end of the given result array.

This method is called from CIData.toString(), and assumes related list lines are to be indented two spaces.

Table 18. Parameters
Name Type Description
result Array The result to convert
Table 19. Returns
Type Description
void

CIRelatedList - toXML(String document, String element)

Serializes this instance to XML in the given document and <rl> element.

Table 20. Parameters
Name Type Description
document String The document
element String The rl element
Table 21. Returns
Type Description
void

CIRelatedList - remove()

Removes all the related list items.

Table 22. Parameters
Name Type Description
None
Table 23. Returns
Type Description
void

Example

This code example deletes the related records mapped with the CI items with the name = *JEMPLOYEE-IBM. This example is for a non-M2M table.

//Get a configuration item record which has a related list. Example:  CI items with the name = *JEMPLOYEE-IBM.
var ciRecord = new GlideRecord("cmdb_ci_computer");
ciRecord.addQuery("name", "*JEMPLOYEE-IBM");
ciRecord.query();
if (ciRecord.next()) {

    var relRecordTable = 'cmdb_ci_network_adapter'; // The table containing the related list (if many-to-many, the many-to-many table)
    var relRecordField = 'cmdb_ci'; // The reference field in the table for this related list
    var cmdb_ciHasRelRecord = ciRecord.sys_id; // The sys_id of the CI this list is related to.
    var debugFlag = 'true'; // True if debug logging is enabled.

    // Get the related record List
    var CIRelatedList = new CIRelatedList(relRecordTable, relRecordField, cmdb_ciHasRelRecord, debugFlag);
    CIRelatedList.remove(); // Delete all related records
}

CIRelatedList - xmlToRecord(String records, String element)

Converts a related list from XML to record format.

Table 24. Parameters
Name Type Description
records String The record to create
element String The XML element
Table 25. Returns
Type Description
void