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

Shishir Srivast · ‎07-09-2017

In that case you can try the provided GlideAjax (onChange and Script Include scripts), that would be a good option as per the performance prospective.

chirag_bagdai · ‎07-09-2017

Hi Vivek,

I checked your PDI - You don't need use Script Include or GlideAjax instead you can use g_form.getRefernce('FIELD');

Just inactivate your current client script and create new onChange client script with below script:

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

         var caller = g_form.getReference('guest', doAlert);

}

function doAlert(caller) {

         if (caller.vip == 'true')

                   g_form.showFieldMsg('guest', 'User is VIP');

         else

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

}

vivektietkumar · ‎07-09-2017

Thanks. I had this working already with client script alone but wanted to do it with scratchpad and then GlideAjax so that I can get some practice on these concepts.

Shishir Srivast · ‎07-09-2017

Hi Vivek,

I don't think that's possible to use g_scratchpad (via Business Rule) and then GlideAjax also I don't think there would be any performance issue if you use getReference() with a callback.

GlideForm (g form) - ServiceNow Wiki

Dhruv Chandan · ‎07-10-2017

Hi Srivastava,

Is it a display business rule ?. I tried the same in Display Business rule and it worked fine.

Hope this helps.

Regards,

Dhruv Chandan