remove unused phone numbers and emails

[livewire]

Hi

i usually delete leads which are deleted from the CRM through the mysql database where delete = 1

the problem is that the below tables keeps on growing

entity_email_address - 495254
entity_phone_number - 533688

email_address - 234587
phone_number - 325471

total leads - 112000

when i search delete = 1 on the other tables it doesn't return any records. usually the leads contain only 1 email and phone number

is there a way to clear the details which are not in use?

[victor]

livewire,

- Check if you have a check mark In Administration > Settings > Clean up deleted records option.
- Check if you have Active in Administration > Scheduled Jobs > Clean-up. it is advisable to set a more frequent execution period for this Scheduled Job (for example, once a week).

Both of these steps are interrelated and should help.

[ThomasB]

Also check https://docs.espocrm.com/administrat...rams/#clean-up

If they are not configured they take the default values.

E. g.: cleanupDeletedRecordsPeriod

If this is not set, it defaults to 3 months. Records are only be deleted if they are marked for deletion and the delete date has passed 3 months.

[victor]

E. g.: cleanupDeletedRecordsPeriod

If this is not set, it defaults to 3 months. Records are only be deleted if they are marked for deletion and the delete date has passed 3 months.

You can add the cleanupDeletedRecordsPeriod option in data/config.php. However, it is better and more correct to do it through the UI.

[ThomasB]

No, "cleanupDeletedRecordsPeriod", "Clean Up deleted records" optionand "Scheduling" are something completely different!
Scheduling just says, when the clean-up job should run.

cleanupDeletedRecordsPeriod defines how old the deleted records have to be. If you remove an item, it will be flagged for deletion. When the modified date of the item has passed 3 months, only then the clean-up job will remove it from the database.