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-10-2017

Hi Dhruv,

Display BR will work with g_scratchpad but I am not sure if that will help with onChange client script to show the message if there is any change in Guest name.

Dhruv Chandan · ‎07-10-2017

Hi Srivastava,

Yes, it'll work in sync with OnChange Client Script. I've tested that too.

Regards,

Dhruv Chandan

Harsh Vardhan · ‎07-10-2017

Yes . it will work .

Shishir Srivast · ‎07-10-2017

Perfect, I must have missed something then in my testing. Let me try

Thank you!

Shishir Srivast · ‎07-10-2017

@Dhruv Chandan, @harsh vardhan

Can you let me know what script are you using? for me it's always returns false.