We'd love to hear from you! Provide  feedback  to earn a badge today. Take our quick survey
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Querying FATTACH table - bulk delete attachments

Accepted answer
edited Oct 26, 2016 12:53PM in Integrations and APIs 6 comments



We built up a backlog of file attachments, but we're at the point now where we want to bulk delete the existing backlog of files attached to incidents, and then to run a regular deletion process following that to delete any file attachment created more than xx days ago. 

We can query the incident table, look to see if there are attachments, call up the information that way and delete as we go. The problem is that we have to look at every incident to see if it HAS an attachment.

The ideal method would be to directly query the FATTACH table, check the date, and delete the files that way.

Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!