The Zurich release has arrived! Interested in new features and functionalities? Click here for more

g_scratchpad not working

vivektietkumar
Giga Contributor

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.

1 ACCEPTED SOLUTION

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

77 REPLIES 77

Sorry for dragging this but I am still having issues. I got the error mentioned above resolved by making the changes you recommended.


I was still getting the following error:


Script: hotel1.DisplayUserDetails not found in scope: x_53167_hotel1, and HTTP Processor class not found: hotel1.DisplayUserDetails: no thrown error



So I changed the script as:



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


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


return;


}


var sys_id = newValue;


var userDetails = new GlideAjax("x_53167_hotel1.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', 'User is a VIP');


else


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


}


}



var DisplayUserDetails = Class.create();


DisplayUserDetails.prototype = Object.extendsObject(global.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'


});




I still just get false in the caller field even when I pick VIP caller although the message is now displayed correctly on who is VIP or not



Looking at the logs I found the error - Did not find content in CDN for x_53167_hotel1_check_in_list-normal. Could the above mentioned error be related to this ?



Thanks a lot again


Vivek


Please let me know if I can connect to your PDI and check, please inbox me your login details.


User and pass Harsh


have you set the "Accessible from" field to All Application scope in your script include?


Not able to connect.