Getting the duplicate entry

[Anna_Servicenow]

We a custom table u_pets, when certain conditions match the new entry will be treated as duplicate. Now, how change the status of all records created except the first one to duplicate. Below is my script that is returning all record matching condition.

var gr = new GlideRecord('u_pets');

    gr.addEncodedQuery('case_id=f4fe7db01b439585d8cd4bcb01^amount=100');

 gr.addQuery('sys_created_on', '>', gs.daysAgo(30));

  gr.orderBy('sys_created_on');

    gr.query();

while (gr.next()) {

       gs.print(gr.number);

     gr.state=8;

         }

[Voona Rohila]

Hi @Anna_Servicenow 

Try this 

var gr = new GlideRecord('u_pets');
gr.addEncodedQuery('case_id=f4fe7db01b439585d8cd4bcb01^amount=100');
gr.addQuery('sys_created_on', '>', gs.daysAgo(30));
gr.orderBy('sys_created_on');
gr.query();
gr.next();//Skip the first record
while (gr.next()) {
    gs.print(gr.number);
    gr.state=8;
   //gr.update();
}

[Anna_Servicenow]

This is excluding first record but now the gr.state = 8 update is not happening. Is this related?

[Voona Rohila]

Uncomment the gr.update() line and run the code.

[Voona Rohila]

Did you get chance to check my answer?

If your issue is resolved now.

If yes, can you please mark appropriate response as correct for others who may have a similar question in the future and close this unresolved thread.

If not, please let us know if you need any other help