Hi Balram,

So just to confirm this deletes Contour records from the last 14 days??

If that's the case then that's awesome work!

Thanks, C

Hi Craig

Yes this is what we are using to clear down our form entries.

Bal

That's brilliant thanks for your time

:)

So would this just delete all of the entries?

Delete FROM [dbname].[dbo].[UFRecords]

Sorry this is probably a bit late but I needed to do something similar and just found your thread.

Just a heads-up, at least on the instance I've spun up anyway. There's no referential integrity in the db (MS-Sql in my case) between the UFRecords table and the various record value fields UFDataRecordString etc so to truly remove the data you'll also need to clear these tables.

As regards programmatically handling records, you can create a class that derives from ApplicationEventHandler and add an event handler for the RecordStorage events e.g.

        using Umbraco.Core;
        using Umbraco.Forms.Core;
        using Umbraco.Forms.Data.Storage;

        namespace MyUmbracoSite
        {
           public class MyUmbracoApplication:ApplicationEventHandler
           {
                protected override void ApplicationInitialized(UmbracoApplicationBase umbracoApplicationBase, ApplicationContext applicationContext)
                {
                    RecordStorage.RecordInserting += RecordStorage_RecordInserting;
                    RecordStorage.RecordUpdating += RecordStorage_RecordUpdating;
                }

                private void RecordStorage_RecordInserting(object sender, RecordEventArgs e)
                {
                  // do something here, record is in the RecordEventArg object
                }

                private void RecordStorage_RecordUpdating(object sender, RecordEventArgs e)
                {
                    //do something here
                }


           }
        }

To delete a record you can spin up a new instance of the RecordStorage class like so:

    using (var storage = new RecordStorage(ApplicationContext.Current.DatabaseContext))
    {
        storage.DeleteRecord(e.Record, e.Form);
    }

Just adding for completeness in case anyone else drops by :)

is working on a reply...