Show incidents with same configuration item in RITM related list

[Vikram3]

I wanted to show the incidents having same cmdb which RITM has in the RITM related lists. Can someone let me know how to write the relationship for this.

[Harshal Aditya · Accepted solution]

Hi @Vikram3 ,

Hope you are doing well.

You just need to create a relationship (sys_relationship) and add the same in sc_req_item table's related list

Please mark this response as correct or helpful if it assisted you with your question.

Regards,
Harshal

[Vikram3]

Thanks @Harshal Aditya It worked well. But I do have a snag in this. Eventhough the cmdb field is empty in RITM, incidents are visible. It shows around 5k records.

[Harshal Aditya]

Hi @Vikram3,

Please try the below code -

(function refineQuery(current, parent) {

    current.addQuery("cmdb_ci",parent.configuration_item);

    current.addQuery("cmdb_ci","!=","");    

})(current, parent);

[Vikram3]

Thanks much. Appreciate your prompt assistance.