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

Hi Vivek,

sorry i am not able to access your PDI instance . i need credential. would you mind to share the details . inbox me.

or you can create an user as per my name and give me an admin role.

by the way it can be achievable through display business rule. that's the alternate approach "Glide Ajax". there are multiple ways that you can use to accomplish your requirement .

In Client script using "Call Back Function"

Display Br

Client callable Script Include + Glide Ajax+Client script .

vivektietkumar · ‎07-09-2017

I tried to inbox you but it seems that I can only inbox to people who are my fiends or whom I am following. So I have sent you a request... please approve.

Thanks

Vivek

vivektietkumar · ‎07-09-2017

Thank you for accepting my invitation. Its still not allowing me to send you a message. Is it possible for you to inbox me, hopefully I can reply back to it ?

vivektietkumar · ‎07-09-2017

okay now I have got it working to say -

23:42:28.388: x_53167_hotel1 (Get VIP flag): this is test:false

Which is essentially what you have. But one question if I have picked a Guest for which the VIP checkbox is ticked then shouldnt it be true. I tried this use case but then was surprised when it returned False.

Harsh Vardhan · ‎07-09-2017

Glad It worked