Search

directory_1.jpg
1 to 10 of 111
Sort by

Discussion Reply
RE: WORKPACKMTLSTATUS on workorder

Hey If you are not able to replicate the issue in lower enviroments then it is for sure becuase of some modification happened on Production and not a product bug. Is there a recent change migrated/done on Production? Do you have any work order scripts related to Work Order or related tables. If...


Discussion Post
WORKPACKMTLSTATUS on workorder

Hi , Duplicate post after changing the type of discussion. **original post We are facing an critical issue in our production env . Scenario is like this: When user is adding actual material , MXRowUpdateException error is encountered. From the sql debug logs on workorder, we got that two...



Discussion Reply
RE: Methods for easily viewing Assignments on in progress work orders

Joe, the short answer is... Maybe. There can be other statuses in play between APPR and STAFFCOMP: INPRG- Work order started but not yet completed WMATL - Waiting for Materials WPCOND - Waiting for Conditions SUPREVIEW- Need a supervisor to review for some reason (creates an assignment...


Discussion Reply
RE: Methods for easily viewing Assignments on in progress work orders

Tim, Are you using any other WO Status between APPR and STAFFCOMP? Upon initial glance it would appear that any WO in WAPPR is the responsibility of a supervisor, I am not sure how you are assigning the Person Group ownership/attribute to the WO record however, and that anything post APPR is...


Discussion Reply
RE: Methods for easily viewing Assignments on in progress work orders

For the b role custom field in the PERSONGROUPTEAM table, are the values stored exactly as you typed them there, upper case first character and the rest lower case? I've had times where I might have put in some SQL that had, for example status = 'wappr' and that did not get the same results as...


Discussion Reply
RE: Methods for easily viewing Assignments on in progress work orders

Hi Travis, We are using the REP WOPLANACT Object Structure. We added the ASSIGNMENT Source Object ourselves and defined as you can see in the screenshot. ((woclass = 'WORKORDER' or woclass = 'ACTIVITY') and historyflag = 0 and istask = 0 and siteid = 'MAIN') and status in ('APPR','INPRG...

2 attachments


Discussion Reply
RE: Methods for easily viewing Assignments on in progress work orders

Remember, your queries can use substitution variables to decrease the number of queries you need to create. Examples: For Work Orders, your query likely starts with "((woclass = 'WORKORDER' or woclass = 'ACTIVITY') and historyflag = 0 and istask = 0) and…" so, depending on what you need, you can...


Discussion Reply
RE: Methods for easily viewing Assignments on in progress work orders

Tim, Could you provide additional information?: 1) The Object Structure used for the Result Set portlet (A screenshot from the Object Structures application would be best) 2) The SQL from the Saved Query used in that Result Set 3) Clarify: are the Supervisors entering data into Work Order...


Discussion Reply
RE: Methods for easily viewing Assignments on in progress work orders

Amy, thanks so much, and great to hear from a fellow Mainer. The solution you provided looks great, but doesn't look like it would quite fit into our configuration. We are relying on Workflow assignments to drive responsibility for both assigning work orders and executing them, so we actually...