Add Edit button in Affected CIs related list on a change task on CSM and SOW workspaces

[Elena Spıru]

Hello,

I have a requirement to add an Edit button in Affected CIs related list on a change task on CSM workspace and to have the same functionality like the backend Edit button.

Currently we have a custom Edit button on change task that applies a filter to only show Affected CIs that are present in the parent (change request)
Example:

Change request CHG0000011 has only 1 affected CI and one change task CTASK0010054

If I open the change task CTASK0010054 I can see all the details and in the Affected CIs related list the custom Edit button

If I click on the Edit button, I have an applied filter to only show Affected CIs that are present in the parent (CHG0000011):

I need to create a button that does the same logic in CSM and SOW workspaces.
Does anybody know how to achieve that?

Thank you,
Elena

[Elena Spıru · Accepted solution]

Managed to solve it!
Here is the solution:
Backend EDIT:
Insert&stay the existing OOTB "Edit..." button to which I've added the following logic:

Code:

var uri = action.getGlideURI();
var path = uri.getFileFromPath();
var type = parent.getValue('type');
uri.set('sysparm_m2m_ref', current.getTableName());
uri.set('sysparm_stack', 'no');

//get the change task sys id
var m2mObject = uri.toString('sys_m2m_template.do');
var firstSplit = m2mObject.split('collectionID=');
var secondSplit = firstSplit[1].split('&sysparm_collection_key');
var changeTaskSysId = secondSplit[0] + '';

//get the change request sys id
var changeRequest;
var grGetChangeRequest = new GlideRecord('change_task');
if (grGetChangeRequest.get(changeTaskSysId)) {
changeRequest = grGetChangeRequest.change_request + '';
affectedCIChangeTask();
}

function affectedCIChangeTask() {
var parentAffectedCIs = new changeTaskUtils().getCIsFromChangeRequest(changeRequest);

if (parentAffectedCIs) {
uri.set('sysparm_query', 'sys_idIN' + parentAffectedCIs);
uri.set('jvar_no_filter', 'true');
}
}
action.setRedirectURL(uri.toString('sys_m2m_template.do'));

Script include changeTaskUtils:

Code:

var changeTaskUtils = Class.create();

changeTaskUtils.prototype = {

    initialize: function() {},

    getCIsFromChangeRequest: function(changeRequestId) {      

        var cis = [];  

        var grTaskCi = new GlideRecord('task_ci');

        grTaskCi.addQuery('task', changeRequestId);

        grTaskCi.query();

        while (grTaskCi.next()) {

            cis.push(grTaskCi.ci_item + '');

        }      

        return cis + '';

    },

    type: 'changeTaskUtils'

};

Workspaces EDIT:
Created a declarative action "Edit...":

Code:

function executeAction() {

    var changeRequest = g_form.getValue('change_request'); // sys id of 'change_request' field

    var _strLink =

        '/sys_m2m_template.do?' +

        'sys_is_list=true&' +

        'sys_is_related_list=true&' +

        'sysparm_collectionID=' + g_form.getUniqueValue() + '&' +

        'sysparm_referring_url=' + location.pathname + '&' +

        'sysparm_stack=no&' +

        'sys_target=task_ci&' +

        'sysparm_m2m_ref=task_ci&' +

        'sysparm_collection=task&' +

        'sysparm_collection_key=task&' +

        'sysparm_collection_label=Affected CIs&' +

        'sysparm_collection_related_field=ci_item&' +

        'sysparm_collection_related_file=cmdb_ci&';

    var changeReqAffectedCis = new GlideAjax('AssociateCIsToChangeUtil');

    changeReqAffectedCis.addParam('sysparm_name', 'getCIsFromChangeRequest');

    changeReqAffectedCis.addParam('sysparm_changeRequestId', changeRequest);

    changeReqAffectedCis.getXMLAnswer(updateFilter);

    function updateFilter(answer) {

        if (answer) {

            if (changeRequest) {

                _strLink +=

                    'sysparm_query=sys_idIN' + answer + '&' + // Applies the filter

                    'jvar_no_filter=true';

            }

        }

        var win = top.window.open(_strLink, '_self');

        win.focus();

    }

}

Script include AssociateCIsToChangeUtil:

Code:

    getCIsFromChangeRequest: function() {

        var cis = [];

        var changeRequestId = this.getParameter('sysparm_changeRequestId') + '';

        var parentAffectedCIs = new changeTaskUtils().getCIsFromChangeRequest(changeRequestId); //logic is in the server side script include

        return parentAffectedCIs;

    },

This way, inside a change task Affected CIs related list you can only see the Affected CIs present on the parent change request.