Sign in Register
Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at


  • David Emlay 9 posts 29 karma points
    Dec 17, 2012 @ 19:46
    David Emlay
    0

    Deleting Contour Records

    I have roughly 22,000 Contour records I need to delete. I have attemted to use the Coutour admin tools to delete these records but if I try delete more than 10 records at a time it seems to hang forever.

    Does anyone have a suggestion?

    Can I delete records directly from a table in the database and have any child data cascade delete?

    Copy Link

  • Comment author was deleted

    Dec 18, 2012 @ 08:53

    Hi David, are these all records of a form, you could export the form, delete the form (that will also delete the entries) and then import the form

    Or you could work directly against the database, take a look at the UFRecords table 

    Copy Link
  • David Emlay 9 posts 29 karma points
    Jan 07, 2013 @ 20:58
    David Emlay
    0

    Thanks Tim. Thanks for your suggestion on exporting, deleting and then importing the form but I'd like to avoid this process as I have 5 or more custom workflows on the forms and I would have to bring everything down to perform this procedure.

    I have looked at the database and the UFRecords table. I can script the delection of records from this table but I am worried about orphaning data in other tables. I am not a SQL expert but I do see some cascade deletes set on the tables. If I delete from UFRecords, will this reference and delete the required records in the other tables?

    Copy Link
Please Sign in or register to post replies

Write your reply to:

Draft