How do we add reference qualifier for list collector in catalog item.

[shalinihorak]

I have a list collector field in catalog item which is referencing the asset table called u_st_hsm. I have to populate fields on the list collector  based on another variable in the catalog item called location_2 . I also need to add another filter for the list collector to display values which have install_status.value!=3 or Install_status is not In Maintenance. How can we add reference qualifier for this.

the current reference qualifier is

javascript:'location.name='+current.variables.location_2;

variables attributes is

ref_auto_completer=AJAXTableCompleter,ref_ac_columns=name;location,ref_ac_order_by=name,ref_ac_columns_search=true

I need to add filter on the list collector for asset table so that they do not display values with Install_status which have value 3 or In maintenance.

[Brad Bowman · Accepted solution]

If your current reference qualifier is working for the first part, the new one would look more like this, assuming your instance has the out of box value of 3 for 'In Maintenance':

javascript:'location.name=' + current.variables.location_2 + '^install_status!=3';

If your location_2 variable is a reference type, then you would just use 'location=' as reference variables store a sys_id and location is a reference field on the asset table so that would match the value stored in location_2.

Since this is a List Collector variable, your Variable Attributes aren't appropriate or relevant as they only apply to Reference type variables and fields.  You do need one new attribute so that the list filter updates when the value of the location_2 variable changes:

ref_qual_elements=location_2

[palanikumar · Accepted solution]

Hi,

Try the below reference qualifier

javascript:'location.name='+current.variables.location_2+'^install_status!=3';

[Ankur Bawiskar · Accepted solution]

@shalinihorak 

is location the correct field on your custom table which refers to cmn_location table

If it's u_location then update as this

javascript: 'u_location.name=' + current.variables.location_2 + '^install_status!=3';

If my response helped please mark it correct and close the thread so that it benefits future readers.

[Nehal Dhuri]

Hello @shalinihorak ,
Please try following the ref qualifier:
javascript:'location.name='+current.variables.location_2+'^install_status.value!=3^install_status.value!=In maintenance';

replace actual value of In maintenance in ref qualifier

[shalinihorak]

Hi Nehal,

Thanks for your help.

We tried this and it seemed to work.

javascript:'location.name='+current.variables.location_2+'^install_status!=3';

[Nehal Dhuri]

make sure that you are using the value of 'In maintenance' in ref qualifier

[shalinihorak]

what should we include in the variable attributes.

the current variables attributes is-

ref_auto_completer=AJAXTableCompleter,ref_ac_columns=name;location,ref_ac_order_by=name,ref_ac_columns_search=true