Results 1 to 3 of 3

Thread: Module Editing Question

  1. #1
    Join Date
    Jun 2006
    Posts
    8

    Default Module Editing Question

    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

  2. #2
    Join Date
    Jun 2006
    Posts
    8

    Default Re: Module Editing Question

    Any help? Anyone?

  3. #3
    sugarchris's Avatar
    sugarchris is offline Sugar Community Member
    Join Date
    Sep 2005
    Location
    San Francisco, CA
    Posts
    861

    Default Re: Module Editing Question

    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.

Thread Information

Users Browsing this Thread

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

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
  •