Passing Variables to Task "Description" Field

ahsan4 · ‎04-25-2016

Hello All,

I hope you are having a wonderful Monday! I needed to reach out to the community for some assistance and see if anyone can help me figure my problem out. I need to take all the variables and pass them in to the "Description" field in the task (in the workflow). I need to make sure make sure they display in the "description" field in a certain order, skip anything that is null, and each variable is in a new line, etc. The variables are all types (reference, integers, check box, string, etc.) This item has about 35/40 variables but I will provide how I have coded a few of them below. I am getting syntax errors and also the code is not really working.

1) is there a better way that what I have present below?

2) Can you please help me perfect my code below and explain what I might be doing wrong?

Example of my code (have to code this for about 38 variables due to them being displayed in a certain order):

//create a variable that will be appended to as you check each request variable for a value

var new_description;

var event_name = current.variables.event_name;

var event_date_start = current.variables.event_date_start;

var event_time_start = current.variables.event_time_start;

var requested_by = current.variables.requested_by;

if (null !=event_name) {

new_description = (new_description && "Name of Event: " && event_name.toString());

}

if (null !=event_date_start) {

new_description = \n(new_description && "Date Event Will Begin: " && event_date_start.toString());

}

if (null !=event_time_start) {

new_description = \n(new_description && "Daily Start Time: " && event_time_start.toString());

}

if (null !=requested_by) {

new_description = \n(new_description && "Requested By: " && requested_by.toString());

}

current.description = new_description;

***not passing the actual variables over because the page looks too busy for our customer and is overwhelming. that would have taken seconds to do but they wanted me to pass the value into the description field for their full-fillers to be able to read. ***

Community Alums · ‎04-25-2016

I just did a similar type of thing in a workflow, creating a task with the summary of the variables in the description field:

   var gr = new GlideRecord("sc_req_item");

   gr.addQuery("request", current.request.sys_id);

   gr.query();

   while(gr.next()) {

       // Get Owned Variables for Requested Item and sort by Order

       var ownvar = new GlideRecord('sc_item_option_mtom');

       ownvar.addQuery('request_item.number', gr.number);

       ownvar.addQuery('sc_item_option.value','!=','');

       ownvar.orderBy('sc_item_option.order');

       ownvar.query();

   var items = "Summary of " + gr.number + ":   " + gr.cat_item.getDisplayValue() + "\n\n";   

       while(ownvar.next()) {

           var field = ownvar.sc_item_option.item_option_new;

                         var fieldValue = ownvar.sc_item_option.item_option_new.name;

                         // Print variable name

             items += field.getDisplayValue() + ": " + gr.variables[fieldValue].getDisplayValue() + "\n";

         }

   }

task.description = items;

Try that and see if it works for what you need. It does skip null variables and does an 'OrderBy' based on the Order number of the variable. It ends up looking something like this:

++++++

Summary of RITM0016419: Unitize Rental/RPO Unit

Equipment Number: 0987

ETM Order Number: 0987

Tag Number: 05-698

Is this an asset?: No

Characteristic Value: Test

Characteristic Name: Test

Equipment Description: Test

Brand Name: Test

Model Number: Test

Model Year: Test

Serial Number: Test

++++++

Hope that helps!

Cheers,

Tim

View solution in original post

Wesley Breshear · ‎08-25-2017

Hi Tim,

Have you come across this error before?

*** Script: Workflow - Step #3

*** Script: Workflow - Step #4

*** Script: Workflow - Step #5

Evaluator: org.mozilla.javascript.EcmaError: "task" is not defined.

Caused by error in script at line 24

21: gs.info("Workflow - Step #4");

22: }

23: gs.info("Workflow - Step #5");

==> 24: task.description = items;

25: gs.info("Workflow - Step #6" + items);

Thanks,

Wesley

Community Alums · ‎08-25-2017

If you're running this in 'scripts->background', the 'task' object would not exist. Remove that declaration and instead print the 'items' string:

 var gr = new GlideRecord("sc_req_item");

   gr.addQuery("request", 'e94535d40f54430009e4cd8ce1050e84');

   gr.query();

   while (gr.next()) {

           // Get Owned Variables for Requested Item and sort by Order   

           var ownvar = new GlideRecord('sc_item_option_mtom');

           ownvar.addQuery('request_item.number', gr.number);

           ownvar.addQuery('sc_item_option.value', '!=', '');

           ownvar.orderBy('sc_item_option.order');

           ownvar.query();

           var items = "Summary of " + gr.number + ":   " + gr.cat_item.getDisplayValue() + "\n\n";

           while (ownvar.next()) {

                   gs.print("we're Here");

                   var field = ownvar.sc_item_option.item_option_new;

                   var fieldValue = ownvar.sc_item_option.item_option_new.name;

                   // Print variable name   

                   items += field.getDisplayValue() + ": " + gr.variables[fieldValue].getDisplayValue() + "\n";

           }

   }

   gs.print(items);

I just tested this and it works for me on my developer instance. Make sure you're referencing a request which actually has variables on the item that are populated, otherwise it will return nothing.

Tim

Wesley Breshear · ‎08-25-2017

Hi Tim,

Ah! I was thinking it was going to the actual request and that it would see the task.object of the request. So I did what you said and yes my variables printed out. Oddly, it printed all them vs. just the 'true' ones. I am thinking that I will need put in ServiceNow ticket.

*** Script: Summary of RITM0011987: Aspen Access Request

Requested for: Wesley Breshears

Department: 6110-ITS Administration-WH

[Break Line]: undefined

Request type: Modify User

Environment: Stage 2

[Cont. #2 - Level 1]: undefined

ADE Workflow Administrator (ADEWKFLW): true

AvDoc Admins, Denver (AVDOCSADMINDEN): true

AvDoc Admins, NI (AVDOCSADMINNI): false

AvDoc Authors, Denver (AVDOCSAUTHDEN): false

AvDoc Authors, NI (AVDOCSAUTHNI): false

CMA Account Rep (CMAACTREP): false

RCS Authoring Group (RCSAUTHG): false

Thanks,

-Wesley

Wesley Breshear · ‎09-01-2017

Hi Tim,

Would you know how to filter out "undefined" variables (i.e, container splits, line breaks etc.)? These variables/form elements pass an 'undefined' value and I would like to remove them from the listing.

Variables:

Requested for : Me

Manager : Donald Duck (donald.duck@disney.com)

Department : Production Operations-WH

[Break Line] : undefined

Request Type : Request / Order

Category : On-boarding / Access Request

[Container Split] : undefined

Subcategory : Artifactory

Description : Need software access.

Thank you,

-Wesley

Community Alums · ‎09-01-2017

Try adding an 'if' statement around the 'print':

if (fieldValue != 'undefined') {

items += field.getDisplayValue() + ": " + gr.variables[fieldValue].getDisplayValue() + "\n";

}