Hide Related Items that have state retired from Business Application View

[ronro2]

Hello guys!

As you can see in the picture, this is a servicenow back-end form, based on table cmdb_ci_business_app (Extends table Configuration Item).

Do you see under Related Items there that there is a list of Consumes and one of Contains?

If I go into one of the Consumes (Calculated Application Services), it is table cmdb_ci_service_calculated (Extends table Mapped Application Service).

If I go to one of the Contains (Tracked Configuration Files), it is table cmdb_ci_win_server (Extends table Server).

Nothing with status 'retired' should be visible.

Today however they are visible no matter what status they have. How do we do? Two separate Business Rules for each table? Or is it possible to solve with a UI Policy or a Client script? 

Thanks in advance!

[sunil maddheshi]

@ronro2 

 I think you can write before query BR on cmdb_rel_ci  and based on the role for which you dont want to see the retired CI, you can write the script.