Basic/Advanced Lead Management & Callbacks
Posted: Tue Jun 30, 2020 12:30 pmIf I use the basic/advanced lead management tools to transfer leads from one list to another, will it update the list_id in the vicidial_callbacks table for leads with the same lead_id?
There are some leads in older lists that have callbacks set far in the future that we want to retain the lead for but not the lead list. So I thought the best way to accomplish this is to transfer the CBHOLD leads to a "callbacks list".
I'm not well versed enough in SQL to write a query that will update the list_id on both the vicidial_list and vicidial_callbacks tables where the lead_id exists in both tables.
There are some leads in older lists that have callbacks set far in the future that we want to retain the lead for but not the lead list. So I thought the best way to accomplish this is to transfer the CBHOLD leads to a "callbacks list".
I'm not well versed enough in SQL to write a query that will update the list_id on both the vicidial_list and vicidial_callbacks tables where the lead_id exists in both tables.