sandeep61
Tera Contributor

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();}}}

Comments
sudhakar2311
Tera Explorer

Thank you Sandeep. really it helped me.

 

Version history
Last update:
‎02-07-2020 01:18 AM
Updated by: