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.

[shalinihorak]

Hi Ankur, yes the location in the asset table matches with the ones in the dropdown for location_2 variable in the catalog item. The variable has two choice values.Both values are available in the asset table location field.

[Brad Bowman]

We have made assumptions about your custom List table u_st_hsm based on your initial qualifier attempt.  You need to check the field names in this table and change the qualifier accordingly.  Do you have a field named 'location'?  Is it a reference to the cmn_location table?  Do you have a field named 'install_status'? Does it have values similar to the out of box alm_hardware table (3= 'In Maintenance')?

[shalinihorak]

Yes that is correct. location in the asset table u_st_hsm is referencing location table. and the install_status=3  "In maintenance is correct. I was able to fix the issue.Thanks for the help.

[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.

[shalinihorak]

I was able to fix the issue. thanks for your help.