question To copy variable's value into a journal type field in ITSM forum

To copy variable's value into a journal type field

Poorva Bhawsar — Fri, 19 Jan 2024 06:52:56 GMT

Hi Community,

I have few select box variables, if user selects the value of those variables as rejected, rejection reason field will populate. I want to copy the value of those variables if they are rejected along with the rejection reason from sctask to another table's journal type field.

I am thinking about the logic like if xyz == rejected && rejection reason != '' then need to add them in that journal field. If those are not rejected, those i approved i dont want to add them in this journal field.

Thanks,

Poorva Bhawsar

Re: To copy variable's value into a journal type field

Harish KM — Fri, 19 Jan 2024 07:03:47 GMT

Hi @Poorva Bhawsar you can do like you said, to check the value of variable in BR you can do like this

if(current.variables.xyz == 'rejected' && current.rejection_reason !='')

{

//glide another table to pass the values to journal field.

}

Re: To copy variable's value into a journal type field

Poorva Bhawsar — Fri, 19 Jan 2024 09:37:23 GMT

This logic i already told but how to pass those values that i need.

Re: To copy variable's value into a journal type field

Harish KM — Fri, 19 Jan 2024 09:54:48 GMT

Hi @Poorva Bhawsar assuming your BR is on sc task table with before update checked

sample script:

if(current.variables.xyz == 'rejected' && current.rejection_reason !='')

{

var gr = new GlideRecord('tablename');

gr.addQuery('parent',current.sys_id); // parent is the field on the table which holds reference to sc task table

gr.query();

if(gr.next())

{

gr.comments = "Rejected Reason :"+current.variables.variablename +' '+ "Reason": +current.fieldname;

}

Re: To copy variable's value into a journal type field

Poorva Bhawsar — Fri, 19 Jan 2024 10:09:51 GMT

I have multiple variables. Do i need to gliderecord for all or i need to loop for that?

Re: To copy variable's value into a journal type field

Harish KM — Fri, 19 Jan 2024 10:16:48 GMT

Hi @Poorva Bhawsar no need to do multiple glide, you can just pass multiple variables like this

gr.comments += "Rejected Reason :"+current.variables.variablename +' '+ "Reason": +current.fieldname +' '+ "variableName:"+current.variables.variablename +' '+;

gr.comments += variableName1:"+current.variables.variablename1 +' '+;

gr.comments += variableName2:"+current.variables.variablename2 +' '+;,

it will map all your variables to comments field. you can see the mapped values in activity of the record .

Re: To copy variable's value into a journal type field

Poorva Bhawsar — Mon, 29 Jan 2024 05:28:00 GMT

But i have multiple variables and for those multiple variables i have multiple different variables for rejection reasons.

Re: To copy variable's value into a journal type field

Poorva Bhawsar — Mon, 29 Jan 2024 05:28:49 GMT

//var reqtask = new GlideRecord("sc_task");

//reqtask.addQuery('request_item', reqitem.sys_id);

//reqtask.query();

//while (reqtask.next()) {

if (current.variables.vendor_support_in_place_approval == 'failed' && current.variables.rejection_reason3 != ''){

var gr = new GlideRecord('sc_task');

gr.addQuery('parent', current.sys_id);

gr.query();

if(gr.next()){

gr.u_deviation_notes = "Requested Number: " + current.variables.number, "Rejected Reason :" + current.variables.rejection_reason3 +' '+ "Failed :" + current.vendor_support_in_place_approval;

}

if (current.variables.built_as_per_soe_approval == 'failed' && current.variables.rejection_reason1 != '')