Solved

Alert for reopened Work Orders

  • 10 November 2020
  • 2 replies
  • 125 views
C
Rank
Userlevel 6
Badge +17

Hello, 

I am attempting to create a Streams notice for when a Historical Work Order is reopoened. I was attempting to use the Status field of the Historical Work Order, but it appears that field is not available on the table of the LU.

I’m not sure if this is the wrong LU. I have also checked the ActiveSeparate and I do not see it there either.

I’ve looked for STATUS and ROWKEY, but neither appear in either LU/Table. 

Is there another name I should be looking for that represents the Status field on Historical WOs? Any help would be greatly appreciated. 

icon

Best answer by paul harland 11 November 2020, 18:39

View original

2 replies

paul harland
Rank
Userlevel 7
Badge +24

Hi @cjohnson 

If using HistoricalSeparate, I would put the trigger on “Objects are Removed”.  The record is deleted from that table when the work order is reopened.

If that doesn’t work then try using the more general logical unit: WorkOrder, and watch for changes on the WO_STATUS_ID field

C
Rank
Userlevel 6
Badge +17

@paul harland that did it! Thank you! Objects are Removed worked perfectly!

Reply


Terms & ConditionsCookie settings