Set Value with Business Rule when all child records are Closed

[rohiniv]

Hi All,

I want to set one field on parent table when all the child records from custom tables are closed with business Rule.

I need to check each and each record has been closed or not.

Can anyone help me with this.

Thanks & Regards,

Rohini

[Dr Atul G- LNG]

Hi @rohiniv 

Might be give you an idea

https://www.servicenow.com/community/developer-forum/setting-field-value-on-parent-table-when-child-...

[swathisarang98]

Hi @rohiniv ,

you can try with the below code ,

Here i have taken RITM table as parent and child as sc task make the changes according to your requirement,

var gr = new GlideRecord("sc_req_item");
gr.addEncodedQuery("state=1"); // state is open
gr.query();
while(gr.next()) {
	var closedCount = 0;
	var taskRec = new GlideRecord("sc_task");
	taskRec.addQuery("request_item", gr.sys_id);
	taskRec.query();
	var totalCount = taskRec.getRowCount();
	while(taskRec.next()){
			if(taskRec.active.toString() == 'false')
                    {
					closedCount++;
				    }
			            }

			if(closedCount == totalCount && totalCount != 0)
            {
				gr.state = '3'; // update the parent field 
                                gr.update();
			}
		}
		

Please mark this comment as Correct Answer/Helpful if it helped you.

Regards,

Swathi Sarang