Filter List of CI Relationships by Child.Class

Alan Prochaska
Tera Expert

 

I have a dashboard with a List visualization of CI Relationship (cmdb_rel_ci) and I'm adding filters.  In the List viz of CI Relationships (cmdb_rel_ci) I display Parent, Parent.Class, Type, Child, Child.Class.  5 fields and 4M+ rows.  I want to filter by Child.Class, then I'd group by Type or Parent.Class.  I'm not able to create a filter by Child.Class.

 

Some advice says use two filters in a dependent configuration.  I see this working for two filters on Group Member:  first by group, then by user.  It doesn't work when you want to pick the secondary attribute first.

 

When I try to make a filter on Child.Class, it doesn't give me the option to select Class.

I tried making a filter on Table (sys_db_object), which successfully selects a class, but then I can't get it to apply to Child.Class from cmdb_rel_ci.

 

I hope I'm missing something simple.

Thanks for any help.

1 REPLY 1

Mark Manders
Giga Patron

My PDI is sleeping, so I can't check if it works: can you set the filter on something like table.name and then the data to filter on ChildCI.Class.Name. Maybe that will help.


Please mark any helpful or correct solutions as such. That helps others find their solutions.
Mark