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
Thank you Dhana3,
There is no more information about the filters other than what I wrote above (and the filters I made don't work anyway). It is the settings "Filter source" and "Data to filter" that I do not understand how to work with.
But perhaps my description was too complex, so let me try to simplify it as much as possible: How can I set up a filter to follow another filter via a record connection in the CI Relationships table? In this case I want the record referenced in the Child field of a record to follow the record referenced in the Parent field: For example, if I select ThinkStation S20 in filter 1, I want to be able to select Blackberry in filter 2.
When you define the second and subsequent filters, use 'Follow Other Filters'. For example, below I have setup two filters one for 'Assignment Group' and other filter for 'Assigned To' for incident list view. When I filter 'Assignment Group' based on the field value, 'Assigned To' will show only options applicable for that 'Assignment Group'.
Thanks,
Bhuvan
