Skip to main content

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. 

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

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

Reply


Terms & ConditionsCookie settings