Module Editing Question

[theStorminMormon]

I am trying to do a very specific edit. On the home tab I currently have My Open Tasks and My Open Project Tasks. All I want is for the "My Open Project Tasks" to include a grouping by project. I believe that I can do this either by adding a column (which hasn't worked so far) or by simply replacing the module with the projecttask module.

I have been unable to accomplish either of these or find any good instructions on the web (or sugar forums) on how to do this.

Any help?

OS: Windows SBS 2003 (Small Bus Server)
Sugar Suite Version: 4.2
Webserver: IIS 6
PHP Version: whatever's most recent, installed a couple of weeks ago
MySQL: Version 5

[theStorminMormon]

Any help? Anyone?

[sugarchris]

You'll want to dig deep into the query generation code and add "GROUP BY project".

The only issue is of course, I'm not even sure we do a join to the projects table to generate that list; most likely not since a join like that is needlessly expensive if all we want to show is project tasks assigned to you. If a column in that list shows any data that is specific to the Project (like the name), then the join is there, else you're doing a customization that is seriously invasive.