Service Desk Practitioners Forum
cancel

Get the status of all related items via web api

Highlighted
Vlee_1
Valued Contributor.

Get the status of all related items via web api

I am using SD 4.5 SP18 on Windows

A service call can have multiple related work orders, and I need to send out an email notification automatically to the creater of the service call when the last related work order is closed.
can someone please help me with this.



6 REPLIES
Vasily Kamenev
Acclaimed Contributor.

Re: Get the status of all related items via web api

HI
You have several ways, how to do that,
but before: Activate one CF in SC as Numeric.
Create rule by WO side - increment on one this field(SC numeric) by one after WO created. the second rule by WO side - decrease this field by one after WO set "closed". The 3-d rule create sent e-mail when field = 0 by SC.
the ways doing inc/decr: 1. by sd_event, 2. Update by external system, 3. web-api.

Vasily
Vlee_1
Valued Contributor.

Re: Get the status of all related items via web api

Do I need to use the custom calculated fields for this?
Vlee_1
Valued Contributor.

Re: Get the status of all related items via web api

using the suggested method, however, the db rules in WO does not allow me to select the new CF field in SC.
any idea?
Vasily Kamenev
Acclaimed Contributor.

Re: Get the status of all related items via web api

Hi
Activate the field, before using.

Vasily
Vlee_1
Valued Contributor.

Re: Get the status of all related items via web api

The new number custom field in SD is activated, and still I can't see this field from Work Order DB rule.
Vlee_1
Valued Contributor.

Re: Get the status of all related items via web api

The new custom field is visible on DB rule Work order when actions is:
Command Exec Action
Data update from External System
Send e-mail message
but not available when action is Update Data.
I need to update the new Custom field on SC when a new WO is related to a SC by increment 1 and decrement 1 when the WO related to SC is closed.
Can I use the command Exec Action, if so what command line statement should I used?
thanks in advanced for your help.