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...
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...
Hi all, I am using MS Surface Pro to use Maximo Mobile for EAM app. I want to know how is the data storage managed on the local device. I believe everything is stored in the JSON format on the local device but when are they deleted from the local device to free up space? Specially for the...
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
Are you currently involved in the offline data design in mobile for Maximo? Consider the following points and apply it as applicable per your scenarios When it comes to offline data downloads there is a common thinking more is better. This is not true. Offline data download is not about...
Contact us with questions or feedback.
Join CommunityInvite ColleaguesLearn MoreGet Started on MORE
About UsTerms of Use