Lon Landry4
Mega Sage

‎07-12-2024 11:57 AM

 

Thanks for asking, the request_line field on Asset table. Harware Table Schema Map.png

0 Helpfuls

Brad Bowman
Mega Patron
In response to Lon Landry4

‎07-12-2024 12:08 PM

That is a field on an asset that associates it with one RITM. If you don't have a way for multiple RITMs to be associated with an asset, such as they can be OOTB with a CI, and just want your related list to only ever show one record - which is not the best use of a related list, but...

current.addQuery('sys_id', parent.request_line);

 

0 Helpfuls

Lon Landry4
Mega Sage
In response to Brad Bowman

‎07-12-2024 12:18 PM

Yes, I understand I will have a one (asset) to many (RITMs) relationship. Is this possible with scripting?

0 Helpfuls

Brad Bowman
Mega Patron
In response to Lon Landry4

‎07-12-2024 12:24 PM

Relying on the out of the box Request line field on the alm_asset table, you could have one RITM associated with many assets, but not one asset to many RITMs.  To do this you would need to add an asset column to the sc_req_item table, much like the existing configuration_item column.

View solution in original post

Lon Landry4
Mega Sage

‎07-12-2024 12:28 PM

Thanks Brad, that is the path I will take.

0 Helpfuls