We’ve developed some resources to help you work effectively from home during COVID-19 Click to learn more

Recycle bin - Clean up operation leave stale records in Service Extra tables

Hi

We have customer using a couple of Extratables in SuperOffice Service.
They are both linked to a Company / Contact by the Link Filed type eg in the Extrable each record has a column with either contact_id or person_id

Scenario:

If we delete a comapany it ends up in the recycle bin, and after default 14 days it will be removed by the background cleanup process. This backgruound pocess we are told is cleaning up realation tables like phone and email etc.

However it will not clean up records in the extra tables? I guess this is by design?

Would be nice to have option to also specify Service Extra tables to include in the recyle bin background clean up process.
Maybe as section in config-file fore service etc. or even better a checkbox in the extra table design view:

Include In recylce bin cleanup process: [ X ]

RND => Any thoughts of this? 

As a workaround I guess we could create a SQL-script / service script that runs every night that finds and deletes stale records in our extra tables?

Best regards
Anders

RE: Recycle bin - Clean up operation leave stale records in Service Extra tables

Hi,

Anyone having thoughts on this one??

 

/Anders

Av: Anders Larsson 18. feb 2020

RE: Recycle bin - Clean up operation leave stale records in Service Extra tables

Anyone having thougths of this?

Is it not a problem with possible leftovers / orphan extra table entires? 

I think it is...

/Anders

Av: Anders Larsson 11. maj 2020