Passing Variables to Task "Description" Field

ahsan4
Giga Contributor

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

1 ACCEPTED SOLUTION

Community Alums
Not applicable

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

41 REPLIES 41

Community Alums
Not applicable

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


Hi Tim,



Thank you so much for the fast reply.   I will try this in a few minutes but for my understanding, How is this ordering the variables? so If I have like 38 variables and I need to order them in the way a customer wants them to display, where is that being taken place in the script above?  



Thanks again for all the help!


Community Alums
Not applicable

That's might be tricky, as this is a one-shot variable dump, ordering the variables the 'order' number assigned to them on the catalogue item.



Are they wanting to display the variables in a different order than they are on the catalogue item form?



Cheers,



Tim


Yes, that is what is going on.   They want to order it in the way they want to see it in Description.   Which is not the same order they want to see it on the form.   The order of the variables are aligned to display on the form as certain way and they want the variables to be passed in to the description in a different order.