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...
You can go through this document as start - https://s3.amazonaws.com/media.guidebook.com/upload/120144/Sdg7ZaGTBL0nAC3KQ1hW6iotKALmn5e2USY3.pdf
HI all, I am trying to get the WFTRANSACTION.TRANSID field and copy it to a field on my work order when the user routes the the workflow. I have configured my workflow to run the "SETVALUE" action while routing to the next assignment. My set value action uses the relationship WFTRANSACTION to...
I'm looking for a use case and documents that can help me to start my first project of BIM integration in Maximo 7.6.1.2 and how to display 3D models for existing assets in Maximo.
Contact us with questions or feedback.
Join CommunityInvite ColleaguesLearn MoreGet Started on MORE
About UsTerms of Use