Results 1 to 3 of 3

Thread: deleting Leads

  1. #1
    Kupido is offline Sugar Community Member
    Join Date
    Apr 2011
    Posts
    60

    Default deleting Leads

    Hello

    is there a way to delete the leads after converting?
    Why des sugar this not automatic? before sugar i used short time vtiger, in it the leads were automaticlly delete after converting.


    Best regards and thanks.

  2. #2
    rafael.q.g@hotmail.com's Avatar
    rafael.q.g@hotmail.com is offline Sugar Community Member
    Join Date
    Jun 2011
    Location
    Florianópolis - Brazil
    Posts
    782

    Default Re: deleting Leads

    Yes, there is. Both I think all possiblities will need some development.
    One option is you define some event, to run a sql like:
    "update leads set deleted=1 where NOT(contact_id is NULL) or converted=1";

    Then you really delete all this leads.

    Other way is in view.list.php file append a some filters on $where atribute, like:
    PHP Code:
    var $where 'contact_id is NULL and converted=0 ' 
    Rafael Queiroz Gonçalves
    Advanced OMG UML Certified Professional
    Sun Certified Enterprise Architect for the Java Platform
    Sun Certified Programmer for the Java 2 Platform
    IBM Certified Advanced Application Developer - Lotus Notes and Domino
    IBM Certified Application Developer - IBM WebSphere Portlet Factory
    Computer Science Mastering / UFSC - PPGCC

  3. #3
    Kupido is offline Sugar Community Member
    Join Date
    Apr 2011
    Posts
    60

    Default Re: deleting Leads

    Quote Originally Posted by rafael.q.g@hotmail.com View Post
    Yes, there is. Both I think all possiblities will need some development.
    One option is you define some event, to run a sql like:
    "update leads set deleted=1 where NOT(contact_id is NULL) or converted=1";

    Then you really delete all this leads.

    Other way is in view.list.php file append a some filters on $where atribute, like:
    PHP Code:
    var $where 'contact_id is NULL and converted=0 ' 
    Thx a lot for the answer.
    I go the way with the sql

    thx

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Deleting leads with invalid emails from Campaign
    By climbing-alien in forum Help
    Replies: 1
    Last Post: 2011-01-24, 11:54 AM
  2. Deleting Notes & Tasks Associated with Leads
    By brandonpoc in forum Developer Help
    Replies: 2
    Last Post: 2010-05-05, 11:00 AM
  3. Deleting All Leads - Is It Possible?
    By hrawling in forum Help
    Replies: 2
    Last Post: 2007-11-20, 11:29 AM
  4. Replies: 1
    Last Post: 2007-01-17, 08:10 PM
  5. deleting leads
    By jaipal2004 in forum General Discussion
    Replies: 0
    Last Post: 2005-03-23, 10:55 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •