How can I get the values of the record producer variables?

gmorales · ‎11-13-2015

Hello everyone,

I have a record producer with some variables, let say for example url1, url2, url3 type single text, I need to capture the values of these variables(This is the hard part) for a further work. I've tried using producer.variable1, and as planned get the value of the variable , but I need to get all of them using a loop or something similar, I tried to access the producer object but didn't work

var sitesArray = [];
for(var v in producer){
if(v.indexOf('url') > -1){
               var temp = '';
               if( (v.indexOf('url') > -1) && (current.variables[v] != '') ){
                       temp = v.substring(3);
                       if(sitesArray[temp] == null || sitesArray[temp] == undefined){
                               sitesArray[temp] = [];
                       }
                       sitesArray[temp]['url'] = current.variables[v];
               }
}

But seems to not work, if you guys have any suggestions please let me know.

Robert Beeman · ‎11-15-2015

Hello Guillermo,

I played around with a the Create Incident record producer in my personal instance. The variables are included in the producer object and their key starts with the letters "IO" followed by their sys_id. I'm not sure if there is a better/easier way to get the question text than using a GlideRecord query.

This script put the key value pair of all variables in the work_notes for me in my test:

var test = [];

for(var v in producer){ 

   if (v.startsWith("IO")) { //only variables

       var question = new GlideRecord('item_option_new'); 

       question.get(v.substring(2)); // Querying by sys_id to determine question text

       test += question.question_text + ": " + producer[v] + "\n"; // Set key:value pair to variable

   }

}

current.work_notes = test; // Set Work Notes on new record

View solution in original post

jmcagod · ‎03-03-2022

Hi @Robert Beeman ,

Is there a way to display the variable name: value, ie) question_one:answer_one,

instead of Question One: Answer one?

Thank you!