Advanced reference qualifier not working on Lookup Select Box

[Teri Bobst]

I have a variable that references our Consumable table that allows the task worker to check inventory of the RITM.Cat.Item by viewing the consumable entries that match the model of the catalog item.

This works perfectly for a reference variable, but does not display as desired.

I have tried to do this with a Lookup Select Box variable to allow more display fields, but cannot get the model reference qualifier to function properly.

Here is my reference qualifier that works on a Reference variable:

javascript: 'model='+current.request_item.cat_item.model+

'^install_status=6' +

'^stockroom=9035d97937069600361e1f9543990e34'+

'^ORstockroom=94dde053376016c0574f1f9543990ea5'

When I apply this to my Lookup Select Box, all I get is a blank line. I know it is the model qualifier that does not work because if I remove it, then the Lookup works, just does not filter to the current.model.

What do I need to do to get this reference qualifier to work on the Lookup the same as it works on the Reference?

[bernyalvarado]

Have you set the attribute ref_qual_elements ?

Thanks,

Berny

[Teri Bobst]

Hi Berny, I tried, but since I'm not sure what should go there, it did not work.

I tried: ref_qual_elements=model

Is there something else I should put here?

[Michael Ritchie]

Teri, I believe the values in the lookup select boxes are set when the form loads.   So with your reference qualifier being dependent on another variable on the form, it won't evaluate that change to filter the list.   Believe a reference type field is your only option.

Now this said if you are using Service Portal, references show up as drop downs anyway so maybe that helps?

[bernyalvarado]

It should work on lookup select boxes. There's other references on this on the past:

The most referenced perhaps:

Reference Qualifier on Lookup Select Box Variable

Others:

Lookup selectbox reference qualifier

Teri, I'll suggest you simplify your reference qualifier for troubleshooting purposes. That way you can assess which condition is not working.

Thanks,

Berny