question Client Script to set the value in Developer forum

Client Script to set the value

carlh — Wed, 02 Aug 2017 00:37:36 GMT

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

Re: Client Script to set the value

paulmorris — Wed, 02 Aug 2017 00:42:13 GMT

Assuming 'Subcategory' is a Reference Field to the CMDB table, and the field you want to populate is called 'u_ci_field'

On Change - Subcategory Field

g_form.setValue('u_ci_field',newValue);

Re: Client Script to set the value

Raghu Loganatha — Wed, 02 Aug 2017 00:52:50 GMT

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.

Re: Client Script to set the value

carlh — Wed, 02 Aug 2017 00:53:15 GMT

Thanks Paul. The subcategory field is just a choice field. So the value is just the display name and not the sys_id.

that was my concern when asking if having the choice match the display name would work

Re: Client Script to set the value

Raghu Loganatha — Wed, 02 Aug 2017 00:56:13 GMT

Carl,

So do you have same sub category as existing configuration item as well ?

~Raghu.

Re: Client Script to set the value

carlh — Wed, 02 Aug 2017 00:56:47 GMT

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>

Re: Client Script to set the value

carlh — Wed, 02 Aug 2017 01:02:18 GMT

Yes. I'm planning on using the out of box field "subcategory" and the out of box "configuration item".

The values in the subcategory choices are the same as the display names on the cmdb_ci business services so they'll always match that way.

Currently, I have different cmdb_ci reference fields for a few categories and it's caused a lot of mess so I'm trying to clean it up and I think this may do the trick.

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

Re: Client Script to set the value

Raghu Loganatha — Wed, 02 Aug 2017 01:02:21 GMT

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.

Re: Client Script to set the value

carlh — Wed, 02 Aug 2017 01:05:12 GMT

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

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

Re: Client Script to set the value

Raghu Loganatha — Wed, 02 Aug 2017 01:07:40 GMT

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.

Re: Client Script to set the value

carlh — Wed, 02 Aug 2017 01:14:16 GMT

That makes sense To me but id have no way to do it myself

so you're saying

on change,

query cmdb_ci table and if incident.subcategory = cmdb_ci.Display name

set the value of cmdb_ci field to the sys_id of the record that matches in cmdb_ci?

Re: Client Script to set the value

Raghu Loganatha — Wed, 02 Aug 2017 01:23:11 GMT

Carl,

You understood that correct.

~Raghu.

Re: Client Script to set the value

carlh — Wed, 02 Aug 2017 01:29:12 GMT

Cool! Any way you'd provide that script?

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

Re: Client Script to set the value

Raghu Loganatha — Wed, 02 Aug 2017 01:47:23 GMT

Carl,

This is not a recommended method by ServiceNow but i am giving you the script only to over come the issue right now. Would strongly suggest workarounds.

Script:

Make sure you are adding the right field names and use alert conditions if you want to debug.

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

var sys;

var ci = new GlideRecord('cmdb_ci');

ci.addQuery('name',sub);

ci.query();

while(ci.next())

{

sys = ci.sys_id;

}

g_form.setValue('cmdb_ci',sys);

*This will work only when you have a condiguration item with the same display name as of subcategory.

Let me know how it goes and mark Helpful or Answered and make help improve community experience.

~Raghu.

Re: Client Script to set the value

carlh — Wed, 02 Aug 2017 02:14:12 GMT

Thank you for this. I'm curious why this would not be recommended.

Is there a better way?

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

Re: Client Script to set the value

Raghu Loganatha — Wed, 02 Aug 2017 02:15:19 GMT

Carl,

I am not sure about that. Did that work ?

~Raghu.

Re: Client Script to set the value

carlh — Wed, 02 Aug 2017 02:43:28 GMT

this did not work...I created the "onchange" script using the script provided. the fields look to be correct 'subcategory' and 'cmdb_ci'

I opened a new incident, set the category to applications, then I set the subcategory to "ReportingServices" which is a "business service" we use often.

Re: Client Script to set the value

Raghu Loganatha — Wed, 02 Aug 2017 02:48:48 GMT

add this and check if you see the alerts on the form when you change subcategory.
line 8: alert(sub);

line 16: alert(sys);

Re: Client Script to set the value

carlh — Wed, 02 Aug 2017 03:02:38 GMT

Here's the Business Service I'm selecting from that choice list that matches

Alerts Appeared but no value set

Re: Client Script to set the value

Raghu Loganatha — Wed, 02 Aug 2017 03:42:37 GMT

first alert failed for some reason, cant you double check the field name?