
- Post History
- Subscribe to RSS Feed
- Mark as New
- Mark as Read
- Bookmark
- Subscribe
- Printer Friendly Page
- Report Inappropriate Content
on 02-07-2020 01:18 AM
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();}}}
- 387 Views
- Mark as Read
- Mark as New
- Bookmark
- Permalink
- Report Inappropriate Content
Thank you Sandeep. really it helped me.