Display Last Workflow Memo in Application field | Maximo

 Requirement: 

Is it possible to see the last workflow message when I open any record just beside/below the status field? 

Solution: 

Yes, It is possible with 2 different approaches. Let take this example and display the last memo in work order application.

A. Directly with the relationship, no need for a view also. 

B. Create a View to handle a query

A.  Start with easy way, just relationship and display the field

1. add the following relationship to the workorder
• Relationship: LAST_MEMO_VIEW
• Where Clause: ownertable= 'WORKORDER' and ownerid= :workorderid and memo is not null and transid in (select max(transid) from wftransaction where ownerid= :workorderid and memo is not null)
• Child Object: WFTRANSACTION
2. Now in the application designer just add a new text field and put LAST_MEMO_VIEW.MEMO in attribute property and make it read-only also. 
3.