Parent table to get an access to child table column

[Sashi K1]

Hi we have a peculiar requirement. We have cmdb_ci_service as Service and also using as Business System. There is a flag in cmdb_ci_service (custom) which is a boolean field like is_service whether to false/true. False is a system and true is Service.

Now we are having problem from cmdb_ci reference fields when we have a new requirements that DO NOT show Services in Incident/Change/problem where we reference to cmdb_ci table. Requirement is to show ONLY Business Systems (is_service to false).

how do I implement it? Any thoughts?

Thanks

Sashi

[ohhgr]

Hi Sashi,

You can simply add a reference qualifier on your Reference Field like is_service=false

Hope that helps.

Thanks,
Mandar

[Sashi K1]

Well reference qualifier works on the table that you are referring to. If you look at my question, the is_service doesn't exists in parent, it exists in dependent table (cmdb_ci_service). So adding a simple condition reference qualifier doesn't change anything. CMDB just returns all rows including cmdb_ci_service where is_service is TRUE.

[Sashi K1]

reply from neetusingh in Implement

You can simply create a script include and call it as a filter on the intended reference field.

[Sashi K1]

Thanks Neetu Singh

yes, in a way that works. I tried to call an external Javascript and joined parent/child tables to get a results of what I needed. It worked. I have seen SN too implemented this way in few of their dynamic reference qualifier.

But the problem I'm getting is slowness. When I use script include and query it is taking time to load. The time is increased if number of records in cmdb_ci_service with is_service to true.

But this approach works and I have seen SNOW has same way to address such things.

Thanks

Sashi