Search

Answer

RE: MAS 8.11.12: Replicating CLASSSTRUCTURE.HIERARCHYPATH non-persistent Logic in SQL

Hi @Philip Marrone! HIERARCHYPATH is solved by a java class (FldClassStructureHierarchyPath). We have solved it so that, there is an added field called TICKET.CLASIFICACION where CLASSSTRUCTURE.HIERARCHYPATH is pasted, then, when you need to make an SQL query, you add that field and it is solved...

Question

MAS 8.11.12: Replicating CLASSSTRUCTURE.HIERARCHYPATH non-persistent Logic in SQL

Hey everybody. I hope you're having an amazing start to your week: I was attempting to generate the value for the CLASSSTRUCTURE.HIERARCHYPATH field within a DB2 SQL statement, similar to how the application does it. However, since this field is non-persistent and requires specific logic to be...

Discussion Thread 3

Just a question, who in this group uses TRM's Rule Manager.

Discussion Thread 9

Error on Automation Script Object Launch Point

Discussion Thread 5

inventory receiving

Answer

RE: Calculate Estimated Duration ESTDUR on the WORKORDER Object

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

Answer

RE: Calculate Estimated Duration ESTDUR on the WORKORDER Object

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

Question

Calculate Estimated Duration ESTDUR on the WORKORDER Object

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?

Answer

RE: SQL Select First Approver PO and Return PERSON associated with that Change

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

Answer

RE: SQL Select First Approver PO and Return PERSON associated with that Change

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