Can't get checkbox value to be recognized in script include

[Neil Wallace]

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;
},

[Ankur Bawiskar]

Hi,

can you share dictionary screenshot for checkbox?

Is the field name correct which is used in reference qualifier?

Regards
Ankur

[Neil Wallace]

javascript: var query = 'active=true^customer=true^u_pharmacy=' + current.u_pharmacy; query;

Thanks again Ankur, yes it all seems correct. And yet.. it just doesnt recognize it as true.

[vkachineni]

I see the company field as a dropdown with --None--

Can you set choice list specification of company as Choice None instead of dropdown so it shows up as a list picker.

[Neil Wallace]

[vkachineni]

Set that to --None-- so it shows up as a pick list.