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?

[Teri Bobst]

Hi Berny, I will check out the links you provided. I have simplified the ref qualifier and that is how I know it is the model='+current.request_item.cat_item.model that does not work. I can remove it and all other qualifiers function. I have tried only the model qualifier and it will not work.

However, The entire block works perfectly on the reference variable. I just really want the stockroom and quantity to display when the value is selected which will allow the task worker to know at a glance which stockroom to pull the inventory from.

Thanks,

Teri

[bernyalvarado]

Hi Teri,

Do you have this code/functionality within an instance where I can login and take a look? Or lets set some time together. Feel free to send me an email to balvarado@volteo.com

Thanks,

Berny

[Teri Bobst]

Ok, I have done some additional troubleshooting and this is what I have found.

My Lookup variable is a Workflow variable. I can create the same Lookup variable on a catalog item and it works. This makes me think it is an issue with current.field passing correctly from the workflow/task.

This is the reference qualifier for the Lookup Select Box variable added directly to the Catalog item:

Here is a view of the item from the Catalog:

Here is the reference qualifier for the Workflow Lookup Select Box:

And here is what it looks like on a RITM Task:

I have tried multiple variations of current.model and this is the one that works on my reference field. Any ideas as to why the Lookup Select variable created int he workflow would work differently than the one created on the catalog item?

[michaelward]

Teri,

I was fighting with a reference qualifier with the sys_choice as the referenced table for a lookup select box.   What made the filter work for me was a subtle change to the filter string.   In my case, I was using the sys_choice.dependent_value field as the filter.  

This is simplified, but the following did not work:     dependent_value=1234567890

The following did work:   dependent_value=1234567890^EQ

My reference qualifier does do a bit of inline javascript, e.g.   javascript: var refqual='dependent_value='; if (!gs.nil(current.variables.u_service)) refqual+=current.variables.u_service+'^EQ'; refqual;   (there's more but this is the basic approach)

Three key factors in what I did to make my ref qualifier filter work:  

1) added '^EQ' to whatever value is generated by the ref qualifer javascript.

2) make sure the javascript spits out the string by simply referencing it (in my case, refqual;)

3) variable attribute, ref_qual_elements=<variable>   (in my case, 'u_service' is the variable on the form on which by sys_choice reference depends.   Without this attribute, my choice values never change in the list, even if I change my u_service).  

[Teri Bobst · Accepted solution]

Thanks everyone for the input. The solution was way easier than I expected. I was trying model=current.requested_item.cat_item.model since my variable was on the Task form. I finally went to model=current.cat_item.model and it worked just fine. I'm not exactly sure why the dot walked value did not work, but I will take it!