My project task dashlet - does not show all my project tasks

[jonaslagneryd]

Hi,

My project task dashlet - does not show all project tasks assigned to me. I have tired to configure and adjust but do not understand what I can do. Any ideas?

Kind regards
Jonas

» Operating system type and version (Linux, Kernel version 2.6.18-028stab053.17 )
» Sugar Suite version (Version 5.0.0g (Build 3391) )
» Webserver type and version (1.3.41 (Unix))
» PHP version (5.2.5)
» MySQL server version (5.0.45-community-log)

Am working from an Apple Macintosh IBook with OS 10.5.4; surfing with Firefox version 3.0.1.

[nikidinsey]

Can you provide some more information?

Has it worked before?
.. If so have you done anything recently like upgrading, adding extra fields etc.

Is it a live system/

regards

niks

[jonaslagneryd]

Can you provide some more information?

Has it worked before?
.. If so have you done anything recently like upgrading, adding extra fields etc.

Is it a live system/

regards

niks

Hi,
I am very new to SugarCRM so I have not seen the dashlet, on the Home tab, in use before. But I assume it shall present all project tasks assigned to me. I have not added any fields. I am not sure what you mean with live system. I use the Community Edition in real time?

Kind regards,
Jonas

[wjohnson]

I believe there is a bug in 5.0 where you actually had to enter a zero in the percent complete field for it to show up in the dashlet.

Meanwhile I still don't see assigned to as a project task option in 5.0.0g.

[raulreynoso]

I had the same problem. You need to change the status of the task to In Progress. If the status of the project task is set to 'Not Started' It will not show up in your dashlet

[nat8100]

Thanks for this, I too was confused as to why they weren't showing up!

Does anyone know how to make the %complete field '10' by default so ppl don't have to remember to do it each time? or which file to edit?

Thank you

[Stenner]

I've looked into the issue and found a solution.
In modules/ProjectTask/ProjectTask.php you can predefine the value of $percent_complete to 0 by editing the file somewhere around line 65:

before:

var $percent_complete;

after:

var $percent_complete = 0;

That way all new project tasks have the Percent Complete field prefilled with 0, and you don't have to worry about the tasks not showing up in the dashlet.

René Stenner
System Developer
www.proremus.dk

[Stenner]

An alternative solution would be to fix the dashlet itself by taking care of NULL.
Edit the file modules/ProjectTask/Dashlets/MyProjectTaskDashlet/MyProjectTaskDashlet.php around line 59:

before

function buildWhere()
    {
        $resultArray = parent::buildWhere();
        
        $resultArray[] = $this->seedBean->table_name . '.' . "percent_complete != 100";

        return $resultArray;
    }

after

function buildWhere()
    {
        $resultArray = parent::buildWhere();
        
        $resultArray[] = $this->seedBean->table_name . '.' . "percent_complete != 100" . " OR ". $this->seedBean->table_name . '.' . "percent_complete IS NULL";

        return $resultArray;
    }