- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-01-2017 05:37 PM
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
Solved! Go to Solution.
- Labels:
-
Scripting and Coding

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-01-2017 10:55 PM
first create script include mark that check box client callable
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'
});
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);
}
}

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-01-2017 05:52 PM
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-01-2017 05:56 PM
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>

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-01-2017 06:02 PM
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-01-2017 06:05 PM
This is just a choice field on incident . Not referencing another table.
Get Outlook for iOS<https://aka.ms/o0ukef>

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-01-2017 06:07 PM
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.