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...
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...
Contact us with questions or feedback.
Join CommunityInvite ColleaguesLearn MoreGet Started on MORE
About UsTerms of Use