Maximo Open Forum

Hello all,

Would the relationship for this field already exist or would it be difficult to create?

Trying to add a "Last Issue Date to the Asset" in the Spare Parts tab.  So, not just the last date the part was issued, but the last date it was issued to this specific Asset.

Thank you

Hi  Danny! I 

I resolved this request.

In the "Database Configuration" application you need to find the SPAREPART object and add a relationship. In my case it is:

Relationship: A_LASTMATUSETRANS
Child Object: MATUSETRANS
Where:
issuetype = 'DESP' and assetnum = :assetnum and itemnum = :itemnum and matusetransid = (select max (matusetransid) from maximo.MATUSETRANS as MATUSETRANS2 where itemnum = :itemnum and assetnum = :assetnum)

MATUSETRANS kept the transactions in Maximo. (Since the language here is Spanish, the type DESPACHO is DESP. You must replace it with, perhaps, ISSUE. You must go to your database and do your query select distinct issuetype from maximo.MATUSETRANS to obtain the type of data that represents the issue, but it can be ISSUE). From SPARTEPART you relate to the table of movements and look for the type ISSUE. Of those, you need for the last one that will always be, the one with the highest MATUSETRANSID, that's why I look for the MAX(MATUSETRANSID).

So then you add the column and just call relationship.TRANSDATE

Regards!