Create a related list on alm_asset table

Keerthana18
Kilo Contributor

‎02-21-2022 01:55 AM

Have to create a related list called Tasks on alm_asset table. It should show the Incidents, RITMs, etc whenever an Asset has been worked with such tickets.

I have created a relationship it is querying only the Incident records. Help me in querying RITMs.

Labels:
Preview file
71 KB
Preview file
64 KB
0 Helpfuls
  • 708 Views
1 REPLY 1

Brad Bowman
Kilo Patron
Kilo Patron

‎02-21-2022 04:36 AM

Are you populating the Configuration item (cmdb_ci) field on your sc_req_item records with the CI related to the asset record(s) you're looking at?  This doesn't happen out of box since every Catalog Item is different - you have to map one of your variables to this field in a Business Rule or workflow.  Also consider that the Affected Cis related list (cmdb_rel_ci table) may be a better table to query from, if you are taking steps to add other CIs affected by the RITM / Incident / ..., and in this case the CI will need to be linked to the asset record since tasks are linked to CIs not assets.