by mflorell » Mon Feb 27, 2023 7:27 am
The Lead Recycling maximum delay is currently 43199(almost 12 hours) and Lead Recycling was specifically designed never to cross into a second day, hard-coded into the system. So changing this would also be a major project with a ton of testing needed to make sure it does not adversely affect other features.
As for alternatives, I would suggest looking into using a Settings Container with some custom SQL in it with the "AST_settings_container_SQL.pl" script in a crontab entry to reset specific lead statuses at specific times on a regularly scheduled basis. We have set up many clients with this kind of process for all kinds of automated processes, including for extended lead resetting like you have described. Here is some example SQL to put into a Settings Container for this script:
UPDATE vicidial_list SET called_since_last_reset='N' WHERE ( (list_id IN(select list_id from vicidial_lists where campaign_id='TESTCAMP')) and (status IN('NA','N','B')) and called_since_last_reset!='N' and (last_local_call_time < CONCAT(DATE_ADD(CURDATE(), INTERVAL -1 DAY),' ',DATE_ADD(CURTIME(), INTERVAL -3 HOUR));