Multilevel Relationships in Maximo

Hi,

Just a quick tip.

We can have multi level relationships in Maximo.

Lets say you want to show Route Stop description in Work Order:

Following are the relationships:

Parent: WORKORDER

Child: ROUTE

Relationship Name: ROUTES

And the second one is:

Parent: ROUTE

Child: ROUTE_STOP

Relationship Name: ROUTE_STOP

So, the way we can show ROUTE_STOP description in Work Order is:

ROUTES.ROUTE_STOP.Description

The way maximo resolves is from left to right, so the first relation output is the inpput for the next one.

Thought it might help if everyone is not already aware of it đŸ™‚

Regards,

Admin

 

 

Advertisements

3 thoughts on “Multilevel Relationships in Maximo

  1. Brian

    This is great information, but could you be more clear on the steps taken? Is this a new relationship on the ROUTES mbo? Do we add ROUTES.ROUTE_STOP.Description to an existing relationship where clause? I have tested a few different options, but none have worked. Thanks in advance.

    Reply
    1. admin Post author

      What I am trying to show here is you can have following:

      relationship1.relationship2.field_name

      Relationship1 returns a child MBO which acts as a parent for resolving relationship2 and child of that can be used.

      You can use this in any maximo scenario but bear in mind that relationship1 should return a child which in turn should be the parent for relationship2 for this to work.

      Just read through the post again and you will get it.

      Reply
  2. Rustam

    Hello Admin ,
    I have tables table1 and table2.
    we have unique id (un_id1) in the table1 and unique id (un_id2) in the table2.
    But un_id2 is repeating many time for each un_id1 examples:
    table1: table2:
    un_id1 un_id2 un_id2 username address
    1 5 4 user1 aaaa
    2 5 5 user2 bbbbbbb

    My question is how i can create relationship from table1 to table2 .
    I create relationship with condition as un_id2=:un_id2. when i use in the application relationship.username it shows me null information.
    How i can use multiple relationship in my situation? Or there is not needed multiple relationship?
    Please give your comments for my situations.
    Thank you in advance.

    Reply

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s