Can I delete multiple leads (more than 10,000) at a time with a search criteria

[noppann]

Can I do that without playing with SQL query?

Thanks in advance.

[Angel]

Yes, theoretically....

If you set your ListView limit to 10000+ records in System Settings, you would then be able to pull up a listing of leads that is more than 10000 records long. You would then be able to search and select those which you wish to delete. You should be forewarned that it could take some time for it to display so many records in one list. I've never tried it with more than 1000, and even that took a while.

Personally, I think the SQL query route is a much faster approach, but it is feasibility will depend on other variables too.

[noppann]

Yes, theoretically....

If you set your ListView limit to 10000+ records in System Settings, you would then be able to pull up a listing of leads that is more than 10000 records long. You would then be able to search and select those which you wish to delete. You should be forewarned that it could take some time for it to display so many records in one list. I've never tried it with more than 1000, and even that took a while.

Personally, I think the SQL query route is a much faster approach, but it is feasibility will depend on other variables too.

Thanks for the nice idea. I agree with you about using SQL. I'm not sure if it's ok if I just delete all records from "leads" table or not to that is why i hesitate to do so. Now, i'm trying it.

Thank you again

[Angel]

I'm not sure if it's ok if I just delete all records from "leads" table or not to that is why i hesitate to do so.

Should be fine, but if you have calls or other activities (pending or historical) associated with those leads, make sure you delete those records as well. The same is true for the corresponding record that stores any custom fields you may have defined for that module.

Worse case scenario is that the leads would not be in the system, but the other tables would have some orphaned records that need to be cleaned up at some piont.

It shouldn't harm the system in any way.

[noppann]

Thanks a lot. Very informative.