IBM Support

Displaying Additional Information through a Relationship in Maximo

Question & Answer


Question

How can I display additional information from a child record based on a field's value.

Answer

In Maximo you can display information virtually through a relationship.
Sometimes there are situations you may want to display a value from a child table, for the user to see during the session they are viewing the record, but don't need it to be saved to the parent table.

For example you want to display an Asset's serial number in Work Order Tracking when the Asset field is populated.

In Database Configuration there is a Relationship tab.
Most relationships out of the box are the name of the child object.
For the WORKORDER object, on the Relationship tab, you will find an Asset relationship.
Using this relationship, you can add a textbox in App Designer and reference the RELATIONSHIPNAME.ATTRIBUTENAME in the attribute property to display that value when the key of the relationship is populated.

Launch Application Designer.
Select the WOTRACK application.
Select the Object Palette toolbar icon and drag and drop a textbox object onto the Work Order main tab next to the Asset field.
Highlight the new textbox and select the Control Properties icon.
In the attribute field of the properties enter ASSET.SERIALNUM

The ASSET in the attribute value above is the relationship name, not the object name.

Note: Users will be able to modify the original record's value through the relationship.
If this is not a desired functionality, set the inputmode in the properties to Readonly

Save the changes.
In Work Order Tracking, when an asset value is entered, the serialnum value will display in this new textbox virtually for the session.

[{"Product":{"code":"SSLKT6","label":"IBM Maximo Asset Management"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Appl Designer","Platform":[{"code":"PF033","label":"Windows"}],"Version":"6.2.1;6.2.2;6.2.3;6.2.4;6.2.5;6.2.6;6.2.7;6.2.8;7.1.1;7.5;7.6","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}}]

Document Information

Modified date:
17 June 2018

UID

swg21508596