You can synchronize label entries between VTB cards and task records using a business rule.
Table: label_entry
When to run: insert, delete
Script:
(function executeRule(current, previous /*null when async*/ ) {
//Synchronize label entry for task record with label entry for VTB card
if (current.table == "vtb_card") {
//Get VTB card record
var sourceVtbCardRecordGr = new GlideRecord("vtb_card");
sourceVtbCardRecordGr.get(current.table_key);
//Get label entry for task record (if such label entry exists)
var taskRecordLabelEntryGr = new GlideRecord("label_entry");
taskRecordLabelEntryGr.addQuery("table_key", sourceVtbCardRecordGr.task);
taskRecordLabelEntryGr.addQuery("label", current.label);
taskRecordLabelEntryGr.query();
if (current.operation() == "insert") {
//If the current operation is insert and a label entry does not exist for the task record, create one
if (!taskRecordLabelEntryGr.next()) {
var targetTableName = sourceVtbCardRecordGr.task.sys_class_name;
var targetSysId = sourceVtbCardRecordGr.task.sys_id;
var targetClass = (function() {
var targetTaskGr = new GlideRecord(targetTableName);
targetTaskGr.get(targetSysId);
return targetTaskGr.getClassDisplayValue();
}());
var targetNumber = sourceVtbCardRecordGr.task.number;
var targetShortDescription = sourceVtbCardRecordGr.task.short_description;
taskRecordLabelEntryGr.initialize();
taskRecordLabelEntryGr.label = current.label;
if (targetShortDescription != ("" || undefined)) {
taskRecordLabelEntryGr.title = targetClass + " - " + targetNumber + " - " + targetShortDescription;
} else {
taskRecordLabelEntryGr.title = targetClass + " - " + targetNumber;
}
taskRecordLabelEntryGr.table = targetTableName;
taskRecordLabelEntryGr.table_key = targetSysId;
taskRecordLabelEntryGr.insert();
}
} else if (current.operation() == "delete") {
//If the current operation is delete and a label entry exists for the task record, delete it
if (taskRecordLabelEntryGr.next()) {
taskRecordLabelEntryGr.deleteRecord();
}
}
} else {
//Synchronize label entry for VTB card with label entry for target record
//Get VTB record for task if such VTB record exists. Only proceed if it exists.
var targetVtbCardRecordGr = new GlideRecord("vtb_card");
targetVtbCardRecordGr.addQuery("task", current.table_key);
targetVtbCardRecordGr.query();
while (targetVtbCardRecordGr.next()) {
//Get label entry for VTB record (if such label entry exists)
var vtbCardRecordLabelEntryGr = new GlideRecord("label_entry");
vtbCardRecordLabelEntryGr.addQuery("table_key", targetVtbCardRecordGr.sys_id);
vtbCardRecordLabelEntryGr.addQuery("label.name", current.label.name);
vtbCardRecordLabelEntryGr.query();
if (current.operation() == "insert") {
//If the current operation is insert and a label entry does not exist for the VTB card record, create one
if (!vtbCardRecordLabelEntryGr.next()) {
vtbCardRecordLabelEntryGr.initialize();
vtbCardRecordLabelEntryGr.label = current.label;
vtbCardRecordLabelEntryGr.title = "Visual Task Board Card - Created " + targetVtbCardRecordGr.sys_created_on;
vtbCardRecordLabelEntryGr.table = "vtb_card";
vtbCardRecordLabelEntryGr.table_key = targetVtbCardRecordGr.sys_id;
vtbCardRecordLabelEntryGr.insert();
}
} else if (current.operation() == "delete") {
//If the current operation is delete and a label entry exists for the VTB card record, delete it
while (vtbCardRecordLabelEntryGr.next()) {
vtbCardRecordLabelEntryGr.deleteRecord();
}
}
}
}
})(current, previous);
