How to delete duplicate catalog item draft

[Obito]

Hi all,

I need to delete duplicate catalog item draft. I need to only keep last created. There is one question 'Jira ID'  where I am getting unique value from Jira, Based on that question's value I have do the glide aggregate count. If the count is greater than 1 (means there are more than 1 record where Jira Id is same) then I will only keep the latest one.  

How can I write this glide aggregate code?

[GlideFather]

Hi @Obito,

in Portal go to My requests and there is Draft tab where yo ucan erase it:

[GlideFather]

@Obito or in the backend go to [sc_cart_item] table:
https://yourinstance.service-now.com/now/nav/ui/classic/params/target/sc_cart_item_list.do

[Obito]

Hi @GlideFather , Thank you for the response, But I need to delete the records using script.

[GlideFather]

@Obito and by what script - BR, catalog client script (calling Ajax), scheduled job, flow, .... ? 

Not knowing your conditions, to delete it always or under conditions, for all user or just some...?

Then you can write your code accordingly pointing to the table I shared [sc_cart_item].