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