ServiceNow RECORD PRODUCER VARIABLES 

OPTION 1:

var allVars = [];

var sys_id='14d3ca4b1b2ebd50af03dce0b24bcbfc';

var producerVars_allVars = new GlideRecord('question_answer');

producerVars_allVars.addQuery('table_sys_id', sys_id);

producerVars_allVars.addQuery('question.type', '!=', 11);

producerVars_allVars.addQuery('question.type', '!=', 19);

producerVars_allVars.addQuery('question.type', '!=', 20);

producerVars_allVars.query();

while (producerVars_allVars.next()) {

var varName = producerVars_allVars.question.name.toString();

if (!gs.nil(varName)) {

//if (varName == 'business_role_iga') {

var sVar=('VARIABLE NAME: '+producerVars_allVars.question.name.toString() + ' \nVARIABLE VALUE=' +

producerVars_allVars.value);

allVars.push(sVar);

gs.print(sVar);

gs.print('************');

// }

}

}

//gs.print(allVars);

OPTION 2:

//--https://docs.servicenow.com/bundle/vancouver-api-reference/page/script/server-scripting/concept/c_ScriptableServiceCatalogVariables.htmlvar table = 'x_cls_clear_skye_i_group_operations';

var ticketNumber = 'ACR0001191';

var optVariableName = '';

var optVariableName_db = '';

var gr = new GlideRecord(table);

gr.addQuery('number', ticketNumber);

gr.query();

var vars = [];

if (gr.next()) {

for (var prop in gr.variables) {

try {

var variable = gr.variables[prop].getDisplayValue();

var v = gr.variables[prop];

gs.print('variable name :' + prop + '; variable displ value : ' + variable + ' ;variable raw value : ' + v);

try {

var label = v.getGlideObject().getQuestion().getLabel();

var variableName = v.getGlideObject().getQuestion().getName();

gs.print('label :' + label + '; variableName : ' + variableName);

} catch (ex2) {

gs.print('ERR2::' + ex2.toString())

}

} catch (ex) {

gs.print('ERR1::' + ex.toString())

}

}

}

gs.print(vars.toString())

OPTION 2(b):

//-----simpler version:

var table = 'x_cls_clear_skye_i_identity_operations';

//var table = 'x_cls_clear_skye_i_group_operations';

var ticketNumber = 'IDR0001627';

//var ticketNumber = 'ACR0001488';

var optVariableName = '';

var optVariableName_db = '';

var gr = new GlideRecord(table);

gr.addQuery('number', ticketNumber);

gr.query();

var vars = [];

if (gr.next()) {

for (var prop in gr.variables) {

try {

var variable = gr.variables[prop].getDisplayValue();

var v = gr.variables[prop];

if (!gs.nil(variable) || !gs.nil(v)) {

gs.info('VARIABLE NAME :' + prop + '; VARIABLE DISPLAY VAL: ' + variable + ' ;VARIABLE RAW VAL: ' + v);

gs.info('------------');

}

} catch (ex) {

gs.info('ERR1::' + ex.toString())

}

}

}

// gs.info(vars.toString())

OPTION 3:

var allVars = [];

var producerVars_allVars = new GlideRecord('question_answer');

producerVars_allVars.addQuery('table_sys_id', '6212096e477782504410edf1d16d43ea');

producerVars_allVars.addQuery('question.type', '!=', 11);

producerVars_allVars.addQuery('question.type', '!=', 19);

producerVars_allVars.addQuery('question.type', '!=', 20);

producerVars_allVars.query();

while (producerVars_allVars.next()) {

var varName = producerVars_allVars.question.name.toString();

var varValue = producerVars_allVars.value.toString();

if (!gs.nil(varName) && !gs.nil(varValue) ) {

allVars.push(varName + ';' + varValue);

gs.info('VARIABLE NAME:' + varName + ', VARIABLE VALUE:' + varValue);

}

}