Mass delete leads from a list
how can I delete some 100 contacts from a list of 1000 contacts massively
Download your list and delete the 100 contacts and then re-upload it. Or you can do it via SQL commandline.
RE: Mass delete leads from a list - Added by Leopoldo Martinez about 1 month ago
Hello, I am trying to massively delete records from my GAD v4, specifically from the "vicidial_list" list, but I want to delete only the records that in the "status" column say A, AA, B, AB, NP, among others. I use navicat to manage the database, and to delete the records that are no longer functional, I must do it manually. My question is if anyone can help me with any SQL command that works for this purpose. The command I have been trying to use is "DELETE FROM 'asterisk'. 'Vicidial_list' WHERE 'status' = A;" but this doesn't work for me, it tells me that I have a syntax error. Any ideas or help?
You can try using phpmyadmin (https://www.phpmyadmin.net) on your server. This will provide you with a web based GUI for MySQL/MariaDB for easier database navigation.
If you need to do it via SQL CLI, try the following:
mysql asterisk -uroot -p -A
MariaDB [asterisk]> delete from vicidial_list where status="A";