Passing Variables to Task "Description" Field

[ahsan4]

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. ***

[Wesley Breshear]

Hi Max,

I am hoping that now I know your fix.   If I am right, this will be my very first response with a correct answer.   You have a capital "D" in task.description = items; I think this is the reason why it is failing.

I have updated Tim's code (gray regions) which you may want to consider adding yours.   Especially the extra addQuery statements.

// Determine if 'Short Description' field exists, if not use 'Request type', otherwise "undefined" will be used.

var shtDscr = '';

if (current.variables.u_short_description) {

  shtDscr = current.variables.u_short_description;

} else {

  shtDscr = current.variables.u_request_type.getDisplayValue();

}

task.short_description = current.cat_item.name + " - " + shtDscr;

task.contact_type = 'self-service';

task.priority = '3';

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.addQuery('sc_item_option.value','!=','false');

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

  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;

[bhavyacognizant]

This script did not work when  container start and container end  was included. any idea why? and is there any other way i can achieve ?

[bhavyacognizant]

Hi 

This script did not work when  container start and container end  was included. any idea why? and is there any other way i can achieve ?

[apjohn2]

Brilliant - I was looking for a way to solve this very problem and your script worked a treat for me. HUGE time saver here - thanks so much!!

[bevo]

This works great..... The only variable type it fails on (Madrid) is Container Start.  The workflow dies and no SCTask is created.  Our workaround is change container start to a label.  

Here is my flavor, which I made a script include and then reference in multiple workflows:

function passVariablesToDescription(){


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();

     dpv = gr.cat_item.getDisplayValue();
     items = '';

      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.short_description = dpv;
 task.description = items;
}