Clear Email Queue

I think Sam meant option #2 is the one that attached files would remain on the DB (unless a separate SQL query was included for deleting corresponding rows 1st).

I recommend #1 using a keyboard-mouse macro writer (like AutoHotkey).

@hkabiri  Hello expert, I happened to find, even if I click twice delete on All emails screen, these records are still kept in DB.  How is that， any suggestion?

 

@Ahmed  Hello，did you find that even if we click twice on screen, these email data are just mark as deletedrecord=1 and not acutally be cleaned.

I believe (still testing/confirming) these 4 scripts will delete emails based on CreatedDate and all associated attachments.

delete UploadFileRevision
from SMEmail
left join NoteDoc
on SMEmail.CompanyID = NoteDoc.CompanyID and
   SMEmail.RefNoteID = NoteDoc.NoteID
left join UploadFile
on NoteDoc.CompanyID = UploadFile.CompanyID and
   NoteDoc.FileID = UploadFile.FileID
left join UploadFileRevision 
on UploadFile.CompanyID = UploadFileRevision.CompanyID and
   UploadFile.FileID = UploadFileRevision.FileID
Where SMEmail.CreatedDateTime < '2023/06/01' and
    uploadfilerevision.CompanyID is not null

delete UploadFile
from SMEmail
left join NoteDoc
on SMEmail.CompanyID = NoteDoc.CompanyID and
   SMEmail.RefNoteID = NoteDoc.NoteID
left join UploadFile
on NoteDoc.CompanyID = UploadFile.CompanyID and
   NoteDoc.FileID = UploadFile.FileID
Where SMEmail.CreatedDateTime < '2023/06/01' and
    uploadfile.CompanyID is not null

delete NoteDoc
from SMEmail
left join NoteDoc
on SMEmail.CompanyID = NoteDoc.CompanyID and
   SMEmail.RefNoteID = NoteDoc.NoteID
Where SMEmail.CreatedDateTime < '2023/06/01' and
    notedoc.CompanyID is not null

delete SMEmail
from SMEmail
Where SMEmail.CreatedDateTime < '2023/06/01'

I’ve heard horror stories from using scripts like these.

We need Acumatica to address this issue. It’s been YEARS.