FogBugz Technical Support

A forum for technical support discussion related to Fogbugz.
The current FogBugz Knowledge Base can be found at http://help.fogcreek.com/fogbugz.

Posts by Fog Creek Employees are marked:

Documentation
Release Notes
Network Status

Delete old attachments

I would like to delete attachments older than a specific date from my Fogbugz database. Is there a query I can run to do this? I have too many cases to open each one and edit them manually. I want to keep the cases, and I know I can't delete attachments sent in email. Thanks
Aaron Send private email
Wednesday, October 28, 2009
 
 
Find a bugevent for an old date that you want to delete attachments before.  Let's say that bugevent is ixBugEvent 4000 for example's sake.

Then the query becomes

UPDATE Attachment SET sData = '' where ixBugEvent < 4000
Michael H. Pryor Send private email
Wednesday, October 28, 2009
 
 
Which of the above is the correct query to execute?
Todd Day Send private email
Sunday, November 8, 2009
 
 
Use the UPDATE command (safer than actually deleting the row).
Joel Spolsky Send private email
Tuesday, November 10, 2009
 
 

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics
 
Powered by FogBugz Bug Tracking and Evidence-Based Scheduling.