I want to link the State of RITM with the State of SCTASK.

[Yugo Sakuma]

I currently set the following business rules.

var taskGr = new GlideAggregate('sc_task');
taskGr.addAggregate('COUNT');
taskGr.addQuery('request_item', current.getUniqueValue());
taskGr.addActiveQuery();
taskGr.query();
taskGr.next();

if (taskGr.getAggregate('COUNT') > 0) {
    current.setAbortAction(true);
	gs.addErrorMessage("［状況］を更新できません。画面をリフレッシュすると元の値に戻ります。SCTASKを全てクローズすると［状況］は自動で更新されます。");
}

For this script, I'd like to add a restriction that RITM's [State] cannot be changed to [Open] or [Work in Progress] when all SCTASK's [Status] are [Closed(Complete, Incomplete, Skipped)], and a rule that automatically updates RITM's [State] to [Work in Progress] if even one SCTASK's [State] is not [Closed(Complete, Incomplete, Skipped)]

I would like to know a good solution for coding to add the above settings without changing the original script content.

[Yugo Sakuma]

Hi @Rohit99 

Thank you very much.

I will try to implement it in the way you suggested.

Yugo Sakuma

[Rohit99]

Hi @Yugo Sakuma ,

Have you tried the given solution ?

Let me know if you have any questions.

Please mark my response as correct and helpful if it helped solved your question.

Thanks,

Rohit Suryawanshi

[Yugo Sakuma]

Hello @Jitendra Diwak1 

Thank you for your reply

We have already set up a specific flow for the catalog items associated with this RITM and SCTASK.
This business rule is intended to control when a State is manually changed while the flow “Wait for Condition” is waiting for 14 days.

[Jitendra Diwak1]

Hi @Yugo Sakuma,

Is there any assistance is required or we can close this thread.

Please accept my solution if it works for you and thumps up

Thanks

Jitendra