List collector conditions

[Marc_007]

Good afternoon,

     I am trying to set the conditions for list collector(Record Producer). I want the picker to look at name and class columns. I want to see in the class column = business application, application and scanned application and nothing else. Please see attachments. Thanks

[AshishKM · Accepted solution]

Hi @Marc_007 , 

You can create filter condition from list of cmdb_ci table and copy that query and past in Ref qual field.

Example : Add the scanned application on your instance also and then Run it ... and copy the query for List Collector ref qual.

Copy Query.

Note: Variable Attribute will not filter the required data from cmdb_ci to be display under List Collector, this is use to show those column with searching option on those column ( if added ) on poral only and one most important "glide_list" and ref_auto_completer doesnt work together. 

let us know if this work for you.

-Thanks,

AshishKM

[AshishKM · Accepted solution]

Hi @Marc_007 , 

You can create filter condition from list of cmdb_ci table and copy that query and past in Ref qual field.

Example : Add the scanned application on your instance also and then Run it ... and copy the query for List Collector ref qual.

Copy Query.

Note: Variable Attribute will not filter the required data from cmdb_ci to be display under List Collector, this is use to show those column with searching option on those column ( if added ) on poral only and one most important "glide_list" and ref_auto_completer doesnt work together. 

let us know if this work for you.

-Thanks,

AshishKM

[Brad Bowman · Accepted solution]

ref_ac attributes are out of play here as these only affect reference type fields and variables.  If you want the list collector to only show available records in these three classes, try a reference qualifier like this:

sys_class_name=cmdb_ci_business_app^ORsys_class_name=cmdb_ci_appl^ORsys_class_name=cmdb_ci_scanned_application

or whatever the class/table name for scanned applications is - I don't have that in my instances.