Find your people. Pick a challenge. Ship something real. The CreatorCon Hackathon is coming to the Community Pavilion for one epic night. Every skill level, every role welcome. Join us on May 5th and learn more here.

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: