How can I apply a Reference Qualifier only when a field is valued a certain way?

Shane J · ‎01-06-2017

My Change Manager would like the 'Parent' field on Change Request (Task table reference) to be limited to Incident and Problem records only when the Type == Emergency, otherwise the entire Task table can be used. I've got a reference qualifier:

sys_class_name=incident^ORsys_class_name=problem^EQ

But how do I apply it only in that case?

Chuck Tomasi · ‎01-06-2017

Look at using an advanced reference qualifier (a script of your choosing.) Pass the function your type, it can then return the proper filter string (either the above or nothing.)

javascript:myConditionCheck().changeType(current.type);

var myConditionCheck = Class.create();

myConditionCheck.prototype = {

initialize: function() {

},

changeType : function(changeType) {

if (changeType == 'Emergency')

return 'sys_class_name=incident^ORsys_class_name=problem^EQ';

return '';

},

type: 'myConditionCheck'

};

http://wiki.servicenow.com/index.php?title=Reference_Qualifiers

View solution in original post

Chris M3 · ‎01-06-2017

add 'new' before myConditionCheck() in the reference qualifier.

Shane J · ‎01-06-2017

Spell it out for me Mr Martin, just dumping 'new' in there isn't doing anything.

Shane J · ‎01-06-2017

Nevermind, reading is fundamental:

Sorry been a long week! Thanks guys!