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.
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
The best way I would suggest is to go to the list where these options are and use list filtering to create the reference qualifier. For example, if I wanted all catalog items with category Peripherals, I would go to the parent list (sc_cat_item):
Go to the list view of whatever table you are referencing and create your filter. Then right click on the filter and copy query. This will give you a reference qualifier you can use.
Please mark my answer correct and helpful, If this helps you in any way
