Client Script to set the value

carlh
Kilo Guru

Hi All,

Will anyone help me come up with a client script that will copy the value of a subcategory to the Configuration Item field?   I can't write javascript and am in a hurry

I believe it it should be "on change" type.

Incident table

psuedo script

If "subcategory" changes to "anything", set   "Configuration Item" to same as "subcategory"

Will copying the display name into that reference field work if they are the same?

Currently, I have a reporting issue with the way I've enhanced the form and think this may be the quickest fix Until we figure out how to fix the data issue we've created

if I had this script I could remove several ui policies and actions which are becoming confusing and sort of have me cornered at the moment.  

Please let let me know if you can help.

Thanks in advance for your time and assistance!

regards,   Carl

1 ACCEPTED SOLUTION

first create script include mark that check box client callable



find_real_file.png


var test = Class.create();


test.prototype = Object.extendsObject(AbstractAjaxProcessor, {


ajaxFunction_LocationAjax : function() {


var fo='';


var customerID = this.getParameter('sysparm_custid'); //paramter from the client side


var ag = new GlideRecord('cmdb_ci');


ag.addQuery('name', customerID);


ag.query();


while (ag.next()) {


fo= ag.sys_id;



gs.log('value is :'+fo);


}


return fo;


},




type: 'test'


});






find_real_file.png




function onChange(control, oldValue, newValue, isLoading, isTemplate) {


if (isLoading || newValue === '') {


return;


}



//Type appropriate comment here, and begin script below


var customerNo = g_form.getValue('subcategory');


var gajax = new GlideAjax('test'); // call the Script Include class


// call the public method


gajax.addParam('sysparm_name', 'ajaxFunction_LocationAjax');


// pass the sysID to the method


gajax.addParam('sysparm_custid', customerNo);


//callback function is used to return the result, passed to the getXML function


gajax.getXML(callBackLocation);



function callBackLocation(response) {


var answer = response.responseXML.documentElement.getAttribute('answer');


alert(answer);


g_form.setValue('cmdb_ci', answer);


}


}


View solution in original post

41 REPLIES 41

Raghu Loganatha
Kilo Guru

hi Carl,



You should write an onchange client script with similar code as below



var sub = g_form.getValue('subcategory');


g_form.setValue('cmdb_ci',sub);



Let me know if you need further assistance.



~Raghu.


Hi Raghu and thanks for replying. Any chance you'd provide the full script you would use so I can paste and try it?



Get Outlook for iOS<https://aka.ms/o0ukef>


carl,



You have mentioned that the subcateory is a choice list type. Can you check if its referencing the values from some table or its just a choice list ?



~Raghu.


This is just a choice field on incident . Not referencing another table.



Get Outlook for iOS<https://aka.ms/o0ukef>


Carl,



If sub-category is a choice field and configuration item is a reference field. You cannot map these two as the values in both of these fields wont match. However, i can see of on possibility here that is if you have the sub-category in the configuration item table then we can write a script to find matching name and then update it on cmdb_ci field.



~Raghu.