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,

Could you try below line of code in an advanced reference qualifier?

sys_class_name!=cmdb_ci_service^NQsys_class_name=cmdb_ci_service^u_is_service=false

Let me know if that helps you.

Thanks,

Mandar

[brad_hicks · Accepted solution]

Hi Sashi,

You can try putting this in the reference qualifier field but if this doesn't work then the script include option is the way to go.   I was able to replicate this in a demo instance and there is a property that can be enabled on an instance that allows you to filter records based on extended table fields.   The property is glide.ui.list.allow_extended_fields.

ref_cmdb_ci_service.u_is_active=true^EQ

[Sashi K1]

It works like a charm. Awesome, thank you very much for your right solution.

Learnt a new point today