Results 1 to 5 of 5

Thread: HOW TO change order by?

  1. #1
    dekleinemedia is offline A Prolific Poster
    Join Date
    May 2009
    Location
    Netherlands
    Posts
    241

    Default HOW TO change order by?

    Hi,

    I have the following question;

    How can i change the order by function?
    When I create a new projecttask In Project, i would like the Listview Projecttasks to sort by Project Task Id instead of Task Name.

    See screenshot.

    Example;

    Now
    Projecttask Id Task Name
    3 test 3
    2 test 2
    1 test 1

    Wanted
    Projecttask Id Task name
    1 test 1
    2 test 2
    3 test 3

    Someone know how i can change this? Thanks.

    Much Appreciate
    Attached Images Attached Images  
    Kind regards,

    De Kleine Media


    SugarCRM CE v.5.2.0h
    Windows platform
    MySQL v.5.1
    phpMyAdmin - 2.11.2.2
    Apache Server v.2.0

  2. #2
    andopes's Avatar
    andopes is offline A Sugar Hero | Help Forum Moderator
    Join Date
    Jul 2006
    Location
    São Paulo - Brazil
    Posts
    8,335

    Default Re: HOW TO change order by?

    Hi Jordy

    You need to create an extended layoutdefs for Project module. Create the folders and file custom/Extension/modules/Project/Ext/Layoutdefs/layoutdefs.ext.php

    containing something like that:

    PHP Code:
    <?PHP
    $layout_defs
    ['Project']['projecttask']['sort_order'] = 'asc';
    ?>
    Go to Admin -> Repair -> Rebuild Extensions

    Best regards
    André Lopes
    DevToolKit / Project of the Month - June 2009
    Lampada Global Services- Open Source Solutions
    Avenida Ipiranga, 318
    Bloco B - CJ 1602
    São Paulo, SP 01046-010
    Brazil
    Office: +55 11 3237-3110
    Mobile: +55 11 7636-5859
    e-mail: andre@lampadaglobal.com

    Lampada Global delivers offshore software development and support services to customers around the world.
    Lampada is proud to be a SugarCRM Gold Partner, revolutionizing Customer Relationship Management.

    I DO NOT answer questions through PM and Email. If you need some help post your question into SugarForum.

  3. #3
    dekleinemedia is offline A Prolific Poster
    Join Date
    May 2009
    Location
    Netherlands
    Posts
    241

    Default Re: HOW TO change order by?

    Quote Originally Posted by andopes View Post
    Hi Jordy

    You need to create an extended layoutdefs for Project module. Create the folders and file custom/Extension/modules/Project/Ext/Layoutdefs/layoutdefs.ext.php

    containing something like that:

    PHP Code:
    <?PHP
    $layout_defs
    ['Project']['projecttask']['sort_order'] = 'asc';
    ?>
    Go to Admin -> Repair -> Rebuild Extensions

    Best regards
    Hi Andopes,

    Thanks for your reply;
    I have added the following code into my directory lcustom/Extension/modules/Project/Ext/Layoutdefs/layoutdefs.ext.php

    Php code;

    PHP Code:
    <?php
    $layout_defs
    ['Project']['projecttask']['sort_order'] = 'asc'
    unset(
    $layout_defs['Project']['subpanel_setup']['accounts']);
    unset(
    $layout_defs['Project']['subpanel_setup']['activities']);
    unset(
    $layout_defs['Project']['subpanel_setup']['contacts']);
    unset(
    $layout_defs['Project']['subpanel_setup']['opportunities']);
    unset(
    $layout_defs['Project']['subpanel_setup']['cases']);
    unset(
    $layout_defs['Project']['subpanel_setup']['bugs']);
    ?>
    After that i rebuild the Extensions
    But still have same problem; nothing has changed. See screenshot earlier post

    Any ideas?

    Much appreciate
    Kind regards,

    De Kleine Media


    SugarCRM CE v.5.2.0h
    Windows platform
    MySQL v.5.1
    phpMyAdmin - 2.11.2.2
    Apache Server v.2.0

  4. #4
    andopes's Avatar
    andopes is offline A Sugar Hero | Help Forum Moderator
    Join Date
    Jul 2006
    Location
    São Paulo - Brazil
    Posts
    8,335

    Default Re: HOW TO change order by?

    My bad!!!

    There is a missed information!

    PHP Code:
    <?PHP
    $layout_defs
    ['Project']['subpanel_setup']['projecttask']['sort_order'] = 'asc';
    ?>
    André Lopes
    DevToolKit / Project of the Month - June 2009
    Lampada Global Services- Open Source Solutions
    Avenida Ipiranga, 318
    Bloco B - CJ 1602
    São Paulo, SP 01046-010
    Brazil
    Office: +55 11 3237-3110
    Mobile: +55 11 7636-5859
    e-mail: andre@lampadaglobal.com

    Lampada Global delivers offshore software development and support services to customers around the world.
    Lampada is proud to be a SugarCRM Gold Partner, revolutionizing Customer Relationship Management.

    I DO NOT answer questions through PM and Email. If you need some help post your question into SugarForum.

  5. #5
    dekleinemedia is offline A Prolific Poster
    Join Date
    May 2009
    Location
    Netherlands
    Posts
    241

    Default Re: HOW TO change order by?

    Quote Originally Posted by andopes View Post
    Hi Jordy

    You need to create an extended layoutdefs for Project module. Create the folders and file custom/Extension/modules/Project/Ext/Layoutdefs/layoutdefs.ext.php

    containing something like that:

    PHP Code:
    <?PHP
    $layout_defs
    ['Project']['projecttask']['sort_order'] = 'asc';
    ?>
    Go to Admin -> Repair -> Rebuild Extensions

    Best regards
    Hi André,

    Thx for the response.
    Now i have 2 other questions;

    Q1
    In Project --> subpanel Project Tasks --> Project Task List is now well sorted by task ID...

    Now I want the following being sorted by task ID
    Project --> Detailview Projecttasks (see screenshot)

    How to do this?

    Q2

    How can I add an Mass update in
    Project --> Detailview Projecttasks (see screenshot)

    Hope you can help me with this one!
    I very appreciate
    Attached Images Attached Images  
    Kind regards,

    De Kleine Media


    SugarCRM CE v.5.2.0h
    Windows platform
    MySQL v.5.1
    phpMyAdmin - 2.11.2.2
    Apache Server v.2.0

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Configure Tabs wont change order
    By rjohns621 in forum Developer Help
    Replies: 0
    Last Post: 2009-06-02, 12:56 PM
  2. How to change View Change Log link in Cases Module
    By rraushan2007 in forum Developer Help
    Replies: 1
    Last Post: 2008-08-27, 12:06 PM
  3. change the order of the top nav header tabs
    By kazu182 in forum Developer Help
    Replies: 2
    Last Post: 2007-01-04, 06:34 PM
  4. Replies: 5
    Last Post: 2006-02-21, 02:24 PM
  5. Replies: 0
    Last Post: 2006-01-18, 11:26 AM

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
  •