Skip to main content
Solved

Alert for reopened Work Orders

  • November 10, 2020
  • 2 replies
  • 138 views
C
Superhero (Customer)
Forum|alt.badge.img+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. 

Best answer by paul harland

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

R

2 replies

paul harland
Superhero (Employee)
Forum|alt.badge.img+24
  • paul harland
  • Answer
  • November 11, 2020

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
Superhero (Customer)
Forum|alt.badge.img+17
  • cjohnson
  • Author
  • Superhero (Customer)
  • November 11, 2020

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

Terms & ConditionsCookie settingsAccessibility statement