[HELP] Completed Tasks

[takkischitt]

Is there any way to remove completed Tasks from the Task List without actually deleting the task? i.e. so it remains in the history of the associated account.

[davidboris]

Hello,

You can override function create_new_list_query to eliminate the data you want from the list view of tasks without deleting the tasks.

[takkischitt]

Hello,

You can override function create_new_list_query to eliminate the data you want from the list view of tasks without deleting the tasks.

thanks, how would I go about that?

[blitz2190]

this topic shows how to modify the where clause of the list view query, the first post worked for me
http://www.sugarcrm.com/forums/showthread.php?t=58494

[takkischitt]

this topic shows how to modify the where clause of the list view query, the first post worked for me
http://www.sugarcrm.com/forums/showthread.php?t=58494

Hi thanks for the reply, but I really don't have a clue about coding really so unless someone can take me through the process.....?

[blitz2190]

create a file called view.list.php in custom/modules/Tasks/views (if folder does not exist create it)

with contents

 <?php
if(!defined('sugarEntry') || !sugarEntry) die('Not A Valid Entry Point');

require_once('include/MVC/View/views/view.list.php');

class TasksViewList extends ViewList{
     function TasksViewList()
     {
         parent::ViewList();
     }
     
     /*
      * Override listViewProcess with addition to where clause to exclude project templates
      */
    function listViewProcess()
    {
        $this->processSearchForm();
                

        // RETRIEVE TASKS WHERE THEY ARE NOT COMPLETED
        if ($this->where != "")
            $this->where .= ' and status <> "Completed" ';
        else
            $this->where .= 'status <> "Completed"';

        
        $this->lv->searchColumns = $this->searchForm->searchColumns;
        
        if(!$this->headers)
            return;
            
        if(empty($_REQUEST['search_form_only']) || $_REQUEST['search_form_only'] == false)
        {
            $this->lv->setup($this->seed, 'include/ListView/ListViewGeneric.tpl', $this->where, $this->params);
            $savedSearchName = empty($_REQUEST['saved_search_select_name']) ? '' : (' - ' . $_REQUEST['saved_search_select_name']);
            echo get_form_header($GLOBALS['mod_strings']['LBL_LIST_FORM_TITLE'] . $savedSearchName, '', false);
            echo $this->lv->display();
        }
    }

}

?>  

ALWAYS test on a copy of your install first not the live server