IBM Support

Show the children Asset attachments also in the parent Asset

Technical Blog Post


Abstract

Show the children Asset attachments also in the parent Asset

Body

Have you ever wondered if it's possible to see the children Asset attachments also in the parent Asset?

If so, you have to follow this steps.

 

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.

[{"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

ibm11112307