Question

Purging Entries via SQL Query

Laserfiche SDK Version 9 Administration Integrations

Updated November 18, 2015

asked on November 17, 2015

I would like to find out if anyone is aware of a way in which one can purge a large number of Electronic Files from the Recycle Bin, without having to purge the entire Recycle bin?

I know there is a table that hosts all the Electronic Files pending full deletion our of the Recycle bin, but deleting records from there will only make it seem it is removed from the recycle bin, but the physical Electronic file will still exist on Disk. Therefor I'm looking to find a mechanism that we could run possibly trigger this in SQL wish should run much faster than trying to purge these entries via the LF client, considering there is just over 2.1 Million to be purged.

0 0

Replies

replied on November 17, 2015

the physical Electronic file will still exist on Disk

The Laserfiche server runs a background task to remove the files on disk that are associated with purged documents. It's not unexpected that they aren't immediately deleted, doing so would only make the operation slower.

possibly trigger this in SQL

The SQL server is not capable of removing documents from your volumes. Your only option is to do this through the LF server. There is the option of writing and running an SDK application to do the purging, if you don't want to tie up a client machine.

2 0

replied on November 18, 2015

Thanks for the feedback Brian. Not what I was hoping for but I understand. Will see how we can get this done.

0 0

You are not allowed to follow up in this post.

Question

Question

Purging Entries via SQL Query

Replies

Sign in to reply to this post.