Vinicius had documented the process for adding it to the receiving process but I'm struggling to find the link. I'm thinking it maybe was documented in developerworks and was lost when that was sunset. The design of inspections was intended for it to be added to additional applications with...
Hello, Would like to know the procedure to embed the inspection forms in Create Incident(Oil) application.OOTB Maximo has the inspection forms available only for limited set of applications and would like to get an idea as to what efforts it will take to add the feature to other applications? We...
Thank you for your answers Prashant and Danielle. I've tried what you have both suggested. It still returns me the latest record thats committed to the database. Not the Transid from the workflow transactions that are at that time being created. I have moved my logic to an escalation that will...
Hi Eric, Make a new relationship and try this where clause (child table=WFTRANSACTION). It will get the WF transaction with the most recent date for the WO. ownertable = 'WORKORDER' and ownerid = :workorderid and transdate=(select max(transdate) from wftransaction z where z.ownertable='WORKORDER...
"order by transdate desc" will just reverse the order of values in the set but it is not going to filter and return only 1 latest value. Use max(), row number(), etc. functions depending upon the database that you are using with Maximo to write a query that gives you the latest record. Eg- If I...
Contact us with questions or feedback.
Join CommunityInvite ColleaguesLearn MoreGet Started on MORE
About UsTerms of Use