Inactive Contact 10 Day Minimum

Joseph Pike asked on November 30, 2021 21:42

Hey guys,

Looking at the inactive contact management settings it seems that 10 days is the minimum for the cleanup of inactive contacts. Is it feasible to lower this setting through code? Or would the best course of action be to write a custom service that automatically deletes x contacts every x days? I'm getting about 80k contacts a day from Cloudflare / crawlers which I'm working on filtering out, but want to have this functionality as a backup. Where I can delete say 150k inactive contacts every 2 days during off hours

xperience 13 kentico contacts online marketing

Recent Answers

vasu yerramsetti answered on December 1, 2021 03:47 (last edited on December 1, 2021 04:52)

Option 1:

Minimum value validation coming from database - Refer below screenshot. https://pasteboard.co/MRycx66JJPzM.png You can also change value from database

SELECT TOP (1000) [KeyID]
      ,[KeyName]
      ,[KeyDisplayName]
      ,[KeyDescription]
      ,[KeyValue]
      ,[KeyType]
      ,[KeyCategoryID]
      ,[SiteID]
      ,[KeyGUID]
      ,[KeyLastModified]
      ,[KeyOrder]
      ,[KeyDefaultValue]
      ,[KeyValidation]
      ,[KeyEditingControlPath]
      ,[KeyIsGlobal]
      ,[KeyIsCustom]
      ,[KeyIsHidden]
      ,[KeyFormControlSettings]
      ,[KeyExplanationText]
  FROM [K11eCommerce].[dbo].[CMS_SettingsKey] WHERE KeyName like '%contact%' and KeyID=70072

You can modify the validation rule using update query and update the [KeyValidation] with your own validation rule.

it helps you.

0 votesVote for this answer Mark as a Correct answer