Service Desk Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

DB rule

SOLVED
Go to solution
Highlighted
Janusz Wedolows
Occasional Contributor

DB rule

Hello,

I need to create db rule which can send email when all work orders in service call are closed.

Regards
Janusz
3 REPLIES
Robert S. Falko
Honored Contributor
Solution

Re: DB rule

Janusz,

We do not use work orders with service calls because of cumbersome problems such as this one.

However, suppose you have a way of counting the number of work orders related to a service call, and you maintain that count in a number field in the service call.

The field is initialized as 0. Each time a work order is created, it increments that field by 1. Each time a work order is closed, that field is decremented by 1. When that field is = 0, the DB rule is triggered (only when an existing Service call is saved, not for new Service Calls).

Could this work for you?

-Josh
Janusz Wedolows
Occasional Contributor

Re: DB rule

Yes

thanks
Janusz
Janusz Wedolows
Occasional Contributor

Re: DB rule

.
//Add this to "OnDomLoad" event