Really stuck on an issue and could value some help.
I want the reference qualifier query for the company field to depend on whether pharmacy is checked below:
Have created a reference qualifier as follows:
Passing current into the script include. While it recognizes values already saved to database eg. current state. It doesnt recognize values not saved eg. checkbox u_pharmacy.
Completely stumped. And any help much appreciated.
var GetGPsPharmacySelfRegistration = Class.create();
GetGPsPharmacySelfRegistration.prototype = Object.extendsObject(AbstractAjaxProcessor, {
GetGPsPharmacySelfRegistration: function(ph) {
var gr = new GlideRecord('core_company');
gr.addQuery('active', 'true');
gr.addQuery('customer', 'true');
gs.log('outside');
gs.log('current state' +ph.state);
gs.log('current u_pharmacy' +ph.u_pharmacy);
gs.log('current name' +ph.first_name);
gs.log('check' + current.getDisplayValue('u_pharmacy'));
if (ph.u_pharmacy){
gs.log('inside');
gr.addQuery('u_pharmacy', 'true');
}
gr.query();
var companies='';
while (gr.next()) {
companies += ',' + gr.sys_id;
}
return 'sys_idIN' + companies;
},
Thanks Ankur, have tried your suggestions same thing in the log. Doesnt recognize checkbox as ticked, though does understand it is there.
changed to--->
javascript:new global.GetGPsPharmacySelfRegistration().GetGPsPharmacySelfRegistration1(current.u_pharmacy)
var GetGPsPharmacySelfRegistration = Class.create();
GetGPsPharmacySelfRegistration.prototype = Object.extendsObject(AbstractAjaxProcessor, {
GetGPsPharmacySelfRegistration1: function(ph) {
var gr = new GlideRecord('core_company');
gr.addQuery('active', 'true');
gr.addQuery('customer', 'true');
gs.log('outside');
gs.log('check' + ph.toString());
if (ph.toString() == 'true'){
gs.log('inside');
gr.addQuery('u_pharmacy', 'true');
}
gr.query();
var companies='';
while (gr.next()) {
companies += ',' + gr.sys_id;
}
return 'sys_idIN' + companies;
},
type: 'GetGPsPharmacySelfRegistration'
});
