How to change a disposition via MySQL

[chasejordan1]

Here is the situation, I have an agent that quits and they have 50 CBHOLD's as an example and I want to change those to answering machine so that they go back into list and get recycled. I would think the fastest way to to do that is via SQL query for example something like this UPDATE vicidial_list SET status='A' WHERE status='CBHOLD'; but I want it to be specific to list ID and agent number and that I can seem to figure out.





ALL in one Server.
1.4.39.1-vici
VERSION: 2.4-359a
BUILD: 120213-1512

[williamconley]

Please also post your installation method with version (Vicibox 4.0.3? GoAutoDial 2.1?)

UPDATE vicidial_list SET status='A' WHERE status='CBHOLD' and user='{USER}' and list_id='{LIST_ID}';

Just add "and", then the new criteria.

I would suggest adding a new status like "CBREL" for CallBackRelease to make these visible as released callbacks. In case you want to track stats on these aside from real Answering Machine statuses.

[chasejordan1]

Thank you, as always you are a big help, and I know better when it comes to posting, I will flog myself later

Thad

[williamconley]

never wait 'til later. Besides, it works better if you hire someone to flog you. Frees up your time to get into more mischief.

[DomeDan]

Worth mention: update the vicidial_callbacks table too and set status = INACTIVE because you don't want a callback to be triggered when the lead has an other status then CALLBK or CBHOLD.

else you might end up with this scenario:
* agent A calls a lead and register a "anyone"-callback to 2013-03-25
* you update that lead to NEW in vicidial_list
* agent B calls the lead and register a SALE
* and at 2013-03-25 the lead will be inserted into the hopper even if it was registered as SALE a few days earlier.

be prepared for stuff like this when you starts playing with the vicidial tables.

[williamconley]

! Excellent point DomeDan!

[DomeDan]

Thank you! talking from experience you know, took a while to pin down why NI, SALE etc were being called.