g_scratchpad not working

vivektietkumar · ‎07-08-2017

Hi All, I am trying to learn using g_scratchpad variable in business rules and have made a simple program that is not working, so request some guidance.

1. I have a table called check-in and it has a reference field called guest.

2. I have a table called Guest and that has a field called VIP

3. I want a message to be shown using g_scratchpad when someone tries to checkin a VIP guest.

4. I created a display business rule on checkin table (Get VIP Flag) with the following script:

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

g_scratchpad.vip='current.x_53167_hotel1_guest.vip';

})(current, previous);

5. Then I have the following client script (Alert for VIP)

function onChange(control, oldValue, newValue, isLoading,

isTemplate) {

var showVIP = function() {

g_form.showFieldMsg('x_53167_hotel1_check_in.guest','Guest is a VIP');

};

if (isLoading) {

if(g_scratchpad.vip'){

showVIP();

}

return;

}else{

g_form.hideFieldMsg('x_53167_hotel1_check_in.guest');

}

if(newValue==''){

return;

}

6. The logs dont seem to have any error captured

22:42:32.622: App:Hotel1 ==> 'Get VIP flag' on x_53167_hotel1_check_in:CHE0001128

22:42:32.623: >> Entering scope [x_53167_hotel1]

22:42:32.623: << Exited scope [x_53167_hotel1], popped back into [rhino.global]

22:42:32.623: App:Hotel1 <== 'Get VIP flag' on x_53167_hotel1_check_in:CHE0001128

22:42:32.623: Finished executing before_display before business rules on x_53167_hotel1_check_in:CHE0001128

Please help. Thanks a lot.

Shishir Srivast · ‎07-09-2017

Hi Vivek,

I think you need to do GlideAjax, as per my understanding Business Rule get trigger when form loads or you save the record. When you will do onChange then at time there is no action happening on form. I tried below code and it works fine, please check if this helps.

onChange Client Script:

function onChange(control, oldValue, newValue, isLoading, isTemplate) {

if (isLoading || newValue === '') {

return;

}

var sys_id = newValue;

var userDetails = new GlideAjax("DisplayUserDetails");

userDetails.addParam("sysparm_name", "getUserDetails");

userDetails.addParam("sysparm_sys_id", sys_id);

userDetails.getXML(ajaxResponse);

function ajaxResponse(serverResponse) {

var answer = serverResponse.responseXML.documentElement.getAttribute("answer");

if(answer == 'true')

g_form.showFieldMsg('caller_id', 'User is a VIP');

else

g_form.showFieldMsg('caller_id', 'User is NOT VIP');

}

Script Include:

var DisplayUserDetails = Class.create();

DisplayUserDetails.prototype = Object.extendsObject(AbstractAjaxProcessor, {

getUserDetails : function() {

var sysid = this.getParameter('sysparm_sys_id');

var newUserRecord = new GlideRecord('sys_user');

newUserRecord.addQuery('sys_id', sysid);

newUserRecord.query();

if(newUserRecord.next())

{

var guestIsVIP = (newUserRecord.vip) ? true : false;

return guestIsVIP;

}

},

type: 'DisplayUserDetails'

});

View solution in original post

Harsh Vardhan · ‎07-08-2017

Hi Vivek,

can you change the g_scratchpad.vip to some other variable g_scratchpad.uvip=current.x_53167_hotel1_guest.vip;

vivektietkumar · ‎07-08-2017

Thanks. I tried but still doesnt work but now I see this error in logs

23:02:15.779: Evaluator: org.mozilla.javascript.EcmaError: Cannot read property "vip" from undefined Caused by error in sys_script.a06a2c350f333200890ecf8ce1050e9c.script at line 3 1: (function executeRule(current, previous /*null when async*/) { 2: ==> 3: g_scratchpad.uvip=current.x_53167_hotel1_guest.vip; 4: 5: })(current, previous);

23:02:15.780: Evaluator: org.mozilla.javascript.EcmaError: Cannot read property "vip" from undefined Caused by error in sys_script.a06a2c350f333200890ecf8ce1050e9c.script at line 1 ==> 1: (function executeRule(current, previous /*null when async*/) { 2: 3: g_scratchpad.uvip=current.x_53167_hotel1_guest.vip; 4:

One other observation is that I dont have any condition in the business rule (under Advanced Tab). Is it required ?

Harsh Vardhan · ‎07-08-2017

vivektietkumar · ‎07-09-2017

sorry. it still doesnt seem to work.

org.mozilla.javascript.EcmaError: Cannot read property "vip" from undefined
Caused by error in sys_script.a06a2c350f333200890ecf8ce1050e9c.script at line 3

1: (function executeRule(current, previous /*null when async*/) {
2:
==> 3: g_scratchpad.uvip=current.x_53167_hotel1_guest.vip;
4: gs.info('this is test:' + g_scratchpad.uvip);
5: })(current, previous);

I copied this from system log... also double checked the element name is vip for the field VIP.