var dupRecords = [];

var gaDupCheck1 = new GlideAggregate('incident');

gaDupCheck1.addQuery('active','true');

gaDupCheck1.addAggregate('COUNT', 'short_description');

gaDupCheck1.groupBy('short_description');

gaDupCheck1.addHaving('COUNT', '>', 1);

gaDupCheck1.query();

while (gaDupCheck1.next()) {

sending(gaDupCheck1.short_description);

}

function sending(test){

var c=0;

var initialnumber=0;

var gr= new GlideRecord('incident');

gr.orderBy('number');

gr.setLimit(1);

gr.addQuery('short_description',test);

gr.query();

while(gr.next()){initialnumber=gr.sys_id;

}

var gr= new GlideRecord('incident');

gr.orderBy('number');

gr.addQuery('short_description',test);

gr.query();

while(gr.next()){

c=c+1;

}

varing(initialnumber,c);

function varing(v,c){

var gr1= new GlideRecord('incident');

gr1.orderBy('number');

gr1.addQuery('short_description',test);

gr1.chooseWindow(1,c);

gr1.query();

while(gr1.next()){

gs.info(gr1.number);

gr1.parent_incident=initialnumber;

gr1.parent="";

gr1.update();}}}

Labels: