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...
Hi Prashant, When ordering the result set like this, I added "order by transdate desc" at the end of the where clause. Doing this is still giving me only the last workflow transactions that had been put in the database, it is not returning the transactions that are currently being created. Im...
Check with your vendor regarding a "Q & A" or "Sandbox" environment, we have both at our organization and we use them for testing and training. There is also a "Q & A" environment for report writing (IBM Cognos). Regards
Hello Everyone, Is there any way to get an IBM Maximo / MAS Manage environment for training purposes ? I would be very grateful for you.
Contact us with questions or feedback.
Join CommunityInvite ColleaguesLearn MoreGet Started on MORE
About UsTerms of Use