Relationships Dictionary in Database Configuration | Maximo

Maximo Data Relationship:

Maximo relationship to run query to be an advanced user, below are two documents of all relationship OOB within Maximo to run any query , qbr, etc.

Primary Maximo Data Relationship (PO, Inventory, WO, Asset etc)

Maximo Data Relationship (everything in db configuration)


reference: https://community.ibm.com/community/user/imwuc/browse/blogs/blogviewer?BlogKey=14ca33fc-b99d-4cd2-b413-30248992ff41

Adding Custom Hovers On Field Using Relationships | IBM Maximo

IBM Maximo has provided default Hover windows for some fields. We will explain how to add custom hover window in maximo using custom relationship.

If you want to display the PR Line Item record hovering. The custom relationship can be used with PRLINE object relationship to INVENTORY to retrieve storeroom item information.

• Go to Database Configuration
• Object: PRLINE 
• Create Relationship: PRL_INVENTORY
• Child Object: INVENTORY.
• Where Clause: itemnum=:itemnum and itemsetid=:itemsetid and location=:storeloc and siteid=:siteid

Sorting data of the relationship attributes | IBM Maximo

Sorting:

You cannot sort data of the relationship attributes or non-persistent attributes.

Filtering:

you can filter relationship attribute but not non-persistent attributes.  

reference:  http://www-01.ibm.com/support/docview.wss?uid=