Help with Record Producer Script - Having issues pulling Sys ID

[Wendy Peterson]

Someone helped me with this for a Table I have which in the Record Producer I have tons of variables but they only want to see the ones are that complete. I can get it to pull the values if i tell it the sys id to look for but I can't get it to pull the sys id of the record it just created. Any ideas? See the screenshot below the sys id is there and it's unique. TIA It's for a Record Producer that is put into a table with only like 4 fields and one of them is a comments section it wants the variable values to go into if they are completed. If they aren't completed they don't want to see them.

var gr = new GlideRecord('question_answer');  

gr.addQuery('table_sys_id', current.sys.id); //sys_id of record in question      

gr.query();  

while (gr.next()) {  

  if (gr.value && gr.question.type == 6) { //exclude questions with empty values  

  current.u_comments +=(gr.question.getDisplayValue() + ":   " + gr.value.getDisplayValue() + "\n"); //display question and answer  

  }  

}    

current.u_aom_analyst = gs.getUserID();  

[Wendy Peterson]

Thanks so much for your help. I got this working with your script and making this into a BR.

(function executeRule(current, previous /*null when async*/) {

var sysID = current.getUniqueValue();

var gr = new GlideRecord('question_answer');

gr.addQuery('table_sys_id', sysID); //sys_id of record in question

gr.addNotNullQuery('value');

gr.query();

var myComments = '';

while (gr.next()) {

  if (gr.question.type == 6) { //exclude questions with empty values

        myComments +=(gr.question.getDisplayValue() + ":   " + gr.value.getDisplayValue() + "\n"); //display question and answer

  }

}

current.u_comments = myComments;

myComments.update();

      })(current, previous);

[siva_dirisala]

Hello Wendy, the variables are not inserted into the database by the time the record producer script is run. So, you can move your logic from record producer script to a business rule on the table.

[Wendy Peterson]

Oh dang any ideas on how I would make that script into a BR? I am lost at scripting TIA