Reference Qualifier on Lookup Select Box Variable

[Blair5]

I've been looking through the WIKI/community and it seems like there is a bug with reference qualifiers on Lookup Select box variables. Does anyone know if there is a work around besides making the field a reference variable?

I have 3 variables on a form -- each dependent on the last. The first is a lookup select box and I'd like the second to be a lookup select box with a reference qualifier because setting it as a reference variable gives the same information as the third variable. I've tried only showing the columns I want (with attributes), but it still shows too much.

Is there another angle I can take? Building the list with a script? I only want to show unique values. Any ideas/help would be greatly appreciated because I think I've exhausted all the options I can think of. Thanks!

[tltoulson]

Hi Blair,

If you set a variable using g_form.getValue before you clear the options and then use that variable in a g_form.setValue, you should be able to transfer the value held.  

[Blair5]

Travis,

Would I do this get/setValue in this same script? I tried doing it onSubmit, but didn't hold the value. Or, would I define a new field all together?

[tltoulson]

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

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

   return;   

   }   



   var v = g_form.getValue('fieldname') + '';



   g_form.clearOptions('role'); // Removes all options   



   var gr = new GlideRecord('u_privileged_support_roles');   

   gr.addQuery('u_platform', 'CONTAINS', newValue); // Setup the appropriate query here   

   gr.query();   

   while (gr.next()) {   

     var typeOptions = g_form.getControl('role');   

     var str = typeOptions.innerHTML;   

     if(str.indexOf(gr.u_role_category)==-1){   

   g_form.addOption('role', gr.sys_id, gr.u_role_category);   

     }   

   }   



   g_form.setValue('fieldname', v);

}   

Bare in mind, you may need to clear any reference qualifiers and rely on the script to ensure that the selected value is accepted.

[Blair5]

Travis,

That didn't work either.

[HarshTimes]

Hi Blair

The lookup selectbox reference qualifier works only on load. It does not work on change of a field value. Use reference field instead of this.

Regards

Harsh