IBM Support

Show the assets child record attachments in parent asset record

Technical Blog Post


Abstract

Show the assets child record attachments in parent asset record

Body

Some user would like to view all the attachments being added over the Child records to be visible over the Parent records in applications wherever the attachment provision is present.

 

For you to be able to see the children attachments in the parent asset you have to add a where clause to the relationship.

Please do the following steps:

 

1. Go to Database Configuration application
2. Bring up ASSET object
3. Select the Relationships tab and filter by DOCLINKS
4. Add the following to the end of the relationhip:

or (ownertable = 'ASSET' and ownerid in (select assetuid from asset where parent=:assetnum))

5. Save it.
6. Do a new test.


Now, the full DOCLINKS relationship for the ASSET object is:

 

(ownertable = 'ASSET' and ownerid = :assetuid) or
(ownertable='LOCATIONS' and ownerid=(select locationsid from locations
where location=:location and siteid=:siteid)) or (ownertable='ITEM' and
ownerid=(select itemid from item where itemnum=:itemnum and
itemsetid=:itemsetid and itemtype in (select value from synonymdomain
where maxvalue ='ITEM' and domainid='ITEMTYPE'))) or
(ownertable='TOOLITEM' and ownerid=(select itemid from item where
itemnum=:itemnum and itemsetid=:itemsetid and itemtype in (select value
from synonymdomain where maxvalue ='TOOL' and domainid='ITEMTYPE'))) or
(ownertable = 'ASSET' and ownerid in (select assetuid from asset where
parent=:assetnum))

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSLKT6","label":"IBM Maximo Asset Management"},"Component":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}}]

UID

ibm11112319