- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-08-2017 10:47 PM
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.
Solved! Go to Solution.
- Labels:
-
Personal Developer Instance

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-09-2017 09:45 AM
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'
});
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-12-2017 05:12 PM
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

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-12-2017 05:44 PM
Please let me know if I can connect to your PDI and check, please inbox me your login details.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-12-2017 05:50 PM
User and pass Harsh

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-12-2017 06:23 PM
have you set the "Accessible from" field to All Application scope in your script include?

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-12-2017 06:30 PM
Not able to connect.