var producerVars = new GlideRecord(‘question_answer’);
producerVars.addQuery(‘table_sys_id’, current.sys_id);

There is an index on questions_answer ( table_name, table_sys_id, order ) that is not used because table_name is not being used, but it is available, and can be used to speed up this business rule:

var producerVars = new GlideRecord(‘question_answer’);
producerVars.addQuery(‘table_name’, current.sys_class_name); // ADD THIS LINE TO USE EXISTING INDEX
producerVars.addQuery(‘table_sys_id’, current.sys_id);

Hi Albert,
You can’t do this using this script. Instead, you can create a UI Policy and make the variables not visible and apply it only to the target record.

I sourced my Business Rule from a different blog but took some inspiration from your idea to hide ‘false’ checkboxes (type = 7) Here is the script of my BR:

hideEmptyFields();
function hideEmptyFields() {
var emptyVars = [];
var v;
/* Put all variable values and labels from the variable pool into an array */
for (var i in current.variables) {
v = current.variables[i];
/* Only include empty variables, and exclude Label and Container variables */
if (v == ” && v.getGlideObject().getQuestion().type != 11 && v.getGlideObject().getQuestion().type != 19 && v.getGlideObject().getQuestion().type != 20 || (v.getGlideObject().getQuestion().type == 7 && v.getGlideObject().getValue() == ‘false’)) {
emptyVars.push(v.getGlideObject().getQuestion().getName());
}
}
/* Join the variable values together into a string */
g_scratchpad.emptyVars = emptyVars.join(‘,’);
// gs.log(‘BR – RITM Variables for ‘ + current.number + ‘: ‘ + g_scratchpad.emptyVars);
}

In addition to empty variables, is it also possible to hide specific variables? – In a record producer, I have created several read-only single line texts variables, these texts contain instructions to redirect users to contact somebody else depending on what they have selected in the questions, but these will not make any value to the ticket handler, so I would like to hide these specific variables from the variable editor.

Thanks!

Hi Ashley,

Unchecked check box variables actually have a value of false. They are only ’empty’ from a visual standpoint. Because they have a value, even unchecked check boxes will appear when using this solution. You could exclude all check box variables from the list by modifying the two queries in the code to account for variables with a value of false. Adding a lines like

itemVars.addQuery('sc_item_option.value', false);

and

producerVars.addQuery('value', false);

to the appropriate queries in the code might work.

This is just for standard forms. I don’t have anything for service portal like this currently.