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

vivektietkumar · ‎07-10-2017

Very helpful thanks. I will try these then. Appreciate you taking the time to explain this in detail.

Shishir Srivast · ‎07-10-2017

Hi Vivek,

If I have answered your question, please mark my response as correct so that others with the same question in the future can find it quickly and that it gets removed from the Unanswered list.

If you are viewing this from the community inbox you will not see the correct answer button. If so, please review https://community.servicenow.com/docs/DOC-5601

vivektietkumar · ‎07-10-2017

Thanks. I have already tried it with get reference and it worked fine. But what I wanted to try it with Scratchpad and GlideRecord (both at different times and not at the same time) so that I learn about these two concepts too.