I have one filter on the Service Offering table which should allow selection of Service Offerings that are parents in the cmdb_rel_ci table. This filter is followed by another filter that looks at the Application Service table [cmdb_ci_service_auto], filtering out all Application Services that do not exist in the cmdb_rel_ci table in the Child field in relation to the already selected Service Offering field in the parent table. Finally, there is a third filter running on the Server table [cmdb_ci_server] that should follow the Application Service filter in the same way as the Application Service filter follows the Service Offering filter: it should filter out any Server that is not a Child of the selected Application Service.
I don't want to bore you with details about my attempts, suffice to say that I am stuck on configuring the settings "Filter source" and "Data to filter" on each filter. I have read the docs and tried a variety of combinations but I suppose I'm just not getting it. The closest I've come to making it work is with the following filter (I temporarily left out the particular CMDB extended tables I want to use to simplify things):
Parent filter
Filter source: Configuration Item
Data to filter: CI Relationship.Parent
Child filter
Filter source: CI Relationship
Data to filter: Configuration Item
This works insofar as it filters relationship records on the child based on the CI selected on the parent. However it simply returns a list of SysIDs and I cannot seem to change the display values.
Kudos to one and all who want to help me understand this.
Note that if you set this up in a PDI, the Application Service table may not exist, but as long as you can make it work between any CMDB tables through the CI Relationship table it would be interesting.
Regards,
Kim
@Bhuvan , your solution does not apply in this case. "Assigned to" can follow "Assignment Group" since they are both on the same Incident record, but what I am trying to do is to filter CI records based on parent-child relationships to another CI record via the CI Relationships table.
Have a look at this screenshot. I can set up a "Directly connected filter" between the Configuration Item and CI Relationships table, but not between 2 different records on the Configuration Item table with the CI Relationships table as "middleman". Which makes me think that perhaps it is the other option, "Filters with table connection" that is needed, this after all is the option described in the docs as facilitating a many-to-many relationship connection. Two records in the cmdb_ci table clearly have a connecting table in cmdb_rel_ci - so why does that never show up as an option under "Filters with table connection"? I have tried many combinations but nothing has ever come up.
