Hi Fitzroy, Firstly, let's talk about ESTDUR as this has an impact on the script. ESTDUR is exactly that "the estimated duration of the time to complete the work order". This is opposed to what the field help says, which is "Estimated remaining number of hours needed to complete the work." I say...
Hello Fitzroy! We have approached this as follows. We have a standalone script called DURATION that takes passed parameters and then populates a target field (in this case, ESTDUR) with a calculated value per our business rules. Sample code to invoke the script looks like this: from java.util...
I would like to view the script that calculates the estimated duration (Attribute: "ESTDUR", Object: "WORKORDER"). Would anyone be able to point me to the script that does this calculation?
TRY: SELECT TOP 1 POSTATUS.PONUM ,POSTATUS.CHANGEBY ,POSTATUS.CHANGEDATE APPR DATE FROM POSTATUS WHERE POSTATUS.PONUM = 'PO1234' AND REVISIONNUM = '0' AND POSTATUS.STATUS = 'APPR' ORDER BY POSTATUS.CHANGEDATE
Hi @Adam Olson! I give you this query that may solve your need. SELECT po.ponum, po.revisionnum, po.orgid, po.siteid, po.status, po.changedate, po.changeby, (SELECT MAX(pst.changedate) FROM postatus pst WHERE pst.ponum = po.ponum AND pst.orgid = po.orgid AND pst.siteid = po.siteid AND pst.status...
If I understand you correctly, I've modified your sql to the following. I've used BEDFORD data in an bare Maximo instance, so you'll have to substitue your PONUM in where I've got 1070CS. select ponum, changeby, changedate APPR DATE from postatus where changedate = ( select min(changedate) from...
I'm having difficulty getting a sql statement written that will allow me to return the Minimum Date from the PO Status Table. I'm trying to return the First Approval Date of a PO and also return the CHANGEBY user that is associated with that specific approval. I'm able to successfully get the...
3815 Harrison AvenueCincinnati, OH 45211contact@moremaximo.com
Join CommunityInvite ColleaguesLearn MoreAbout UsTerms of Use