Hide a Catalog Item Reference Variable value if the same value is found on another table.

[mattmm]

1. I have a Catalog Item Variable Referencing the cmdb_ci_server table's name field (e.g. value "WindowsServer1" ).

2. I also have another table cmdb_group_contains_ci table with a reference field called configuration_item, referencing the cmdb_ci table's 'name' field (e.g. value "LinuxServer1")

My Variable is currently showing all name values in the cmdb_ci_server table (point 1. above), but I want to exclude/hide any values that are already present on the cmdb_group_contains_ci table (point 2. above)

.....so that a user cannot choose a server (name) that already exists on cmdb_group_contains_ci table.

I am hoping someone can point me in the direction of the right thing to do and also a possible script/Ref qualifier, or the like, to do this?

Thankyou in advance!

[Community Alums]

It should work as well, just tested with " nameNOT INdocs,examples ", where "docs,examples" are my list values. If the value of your catalog variable pointing to cmdb_group_contains_ci is returning indeed names, then this should work.