How to add reference qualifier in list collector

[Ashwini8]

Hi All,

We have a field called "affected CI" this is a list collector. I have added CMDB table in the reference field. now i have to add 2 child tables of cmdb called "networ" and "circuit" using reference qualifier. In network table when i do group by class i have total 7 clases so i have to include all class and one more table is circuit. Please help how can i add reference qualifier here.

Regards,

tejaswini

[Ankur Bawiskar]

Hi,

what is the existing ref qualifier? do you want to add few more conditions to it?

Regards
Ankur

[Ashwini8]

Affected ci field is exist in catalog item. So in the catalog item i want to add reference qualifier. Please find the below screen shot. Please suggest.

Regards,

Tejaswini

[Ankur Bawiskar]

Hi Tejaswini,

please apply advanced ref qualifier as below detailed steps

In future whenever you want to apply filter

1) go to cmdb_ci table

2) apply filter as class is whatever you want

3) copy the query and paste it below

Ref qualifier on list collector variable:

javascript: 'sys_class_name=cmdb_ci_network_adapter^ORsys_class_name=cmdb_ci_circuit'

screenshot below

Mark ✅ Correct if this solves your issue and also mark 👍 Helpful if you find my response worthy based on the impact.
Thanks
Ankur

[Brad Bowman · Accepted solution]

Navigate to cmdb_ci.list, then filter the list by the criteria you want, then copy the query and paste it in the list collector reference qualifier, so something like

sys_class_name=cmdb_ci_network_adapter^ORsys_class_name=cmdb_ci_endpoint_network