How to bring the age of oldest ticket created in the list of child task (x_sts_claims) to one of the fields in Parent Ticket (x_sts_mains) . Please suggest

[Mishu]

How to bring the age of oldest ticket created in the list of child task (x_sts_claims) to one of the fields[Age of Oldest open child ticket ]  in Parent Table(x_sts_mains) . Any help would be appreciated .

[Mishu]

I tried with display BR on child table with condition as State is Open :

var now = new GlideDateTime();
var created = new GlideTimeDate(current.sys_created_on);
var duration = GlideTimeDate.subtract(created, now);
var value = (duration.getNumericValue() / 1000);
var days = value / 86400;

var aud = new GlideAggregate('x_sts_claims');

aud.addQuery('status' , 'open');
aud.addQuery('parent, current.parent);
aud.addAggregate('MIN', days);
aud.setGroup(false);
aud.query();
while (aud.next()) {

var gr = new GlideRecord ('x_sts_mains');
gr.addQuery('sys_id' , current.parent);
gr.query();

if(gr.next())

{

gr.age_of_child_ticket =aud.getAggregate('MIN', days);

}

[Ankur Bawiskar]

Hi,

you can use display business rule on parent table

1) query child table with this parent and use orderBy('sys_created_on') to get oldest child

I assume your field "Age of Oldest open child ticket" is string type

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

	// Add your code here
	var gr = new GlideRecord("x_sts_claims");
	gr.addQuery("state", "2"); // give correct query to indicate open state
	gr.orderBy('sys_created_on');
	gr.addQuery("parent", current.getUniqueValue());
	gr.setLimit(1);
	gr.query();
	if (gr.next()) {
		var nowTime = new GlideDateTime();
		var childTime = new GlideDateTime(gr.sys_created_on);

		var dur = GlideDateTime.subtract(childTime, nowTime);
		current.fieldName = dur.getDisplayValue();
	}

})(current, previous);

Regards
Ankur

[Mishu]

The output or the aging your script is returning is in days ?

[Ankur Bawiskar]

Hi,

you want in exact days ?

BR would be on parent table and not child

Regards
Ankur

[Mishu]

yes I want to show the aging in days . The current script is not returning the correct age in days.