Update Demand state when Enhancement is Closed Complete

[WaledBajukhaif]

We create Demand [dmn_demand] record, then create enhancement [rm_enhancement] record from the demand record. the demand state changes to Approved once enhancement is created.

My request is when we close enhancement record, update the demand state to Complete.

Any help/thoughts is be appreciated!

Regards

[WaledBajukhaif]

Thanks Sohail for your help i appreciated

I don't have demand field in enhancement form. i created after update BR on enhancement table [rm_enhancement]. I think still something is missing in my script! if you can take a look at it.

(function executeRule(current, previous /*null when async*/ ) {

if (current.state.changesTo('Closed Complete')) {
    var enhState = new GlideRecord('dmn_demand');
    enhState.addQuery('dmn_demand', current.sys_id);
    enhState.addQuery('active', true);
    enhState.query();

    if (!enhState.next()) {
        var demState = current.dmn_demand.getRefRecord();
        demState.state = 'Complete';
        demState.update();
    }
}
})(current, previous);

 Regards,

[Mark Manders · Accepted solution]

The flow should look like this:

And if you insist on using a BR, why not make it simple? Trigger it after update of the enhancement with state = closed and use this:

var demand = new GlideRecord('dmn_demand');
demand.addQuery('enhancement',current.getUniqueValue());
demand.addActiveQuery();
demand.query();
while(demand.next()){
	demand.setValue('state', 9); // completed
	demand.update();
}

[WaledBajukhaif]

The BR worked perfect...

Thanks Mark!