Delete GroupedBy records
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎07-21-2023 10:12 AM - edited ‎07-21-2023 10:29 AM
Hi,
I have a field 'u_custom_key' and when I groupby my records with this field there are records which are having count 2 so I want to delete one of them on the basis of updated field, I want to delete the old one and keep the new one.There are approx 400k records
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎07-21-2023 10:18 AM
Hi,
Add "Created" and/or "Updated" to the column list and pick the one you want to delete.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎07-21-2023 10:30 AM
@Bert_c1 Thanks but there are more than 400k records I don't think manually it would be possible
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎07-21-2023 12:18 PM
Then write a script to do the deletion, run it in Scripts Background.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎07-21-2023 10:19 AM
Hi @Akki1 ,
what is the issue then bring created field and see which is new record and which is old one select the record which you want to delete then click on actions on selected row and select delete.
Regards,
Ranjit
