Search

Answer

RE: Most recent workflow transaction

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...

Answer

RE: Most recent workflow transaction

"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...

Answer

RE: Most recent workflow transaction

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...

Question

Most recent workflow transaction

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...

Discussion Thread 3

Folder Sequence in Attachments

Question

Device Data Storage Management by the Maximo Mobile for EAM App

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...

Discussion Thread 3

Crossover Custom Work Log from Preventive Maintenance to Work Order Tracking

Discussion Thread 3

maximo authenticating to AD LDS instance LDAP

Answer

RE: Training environment

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

Library Entry

Offline Data Design for Mobile - Maximo

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...