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))
UID
ibm11112319