Results 1 to 4 of 4

Thread: Help with filtering Accounts List View by Default

  1. #1
    chrislynch8's Avatar
    chrislynch8 is offline Sugar Community Member
    Join Date
    Oct 2007
    Location
    Cork, Ireland
    Posts
    747

    Default Help with filtering Accounts List View by Default

    Hi,

    This is my question.

    I have 627 Teams that are Automatically created,updated etc every month
    I have over 17000 Accounts in the System

    Team-Accounts relationship is based on job code (type of work done for the Account)

    When an an Account has no job code or one that is not in use the Global team is assigned untill someone starts a new job..

    In my CRM I have approx 7000+ Accounts with the Team Global, so when I go to the Accounts module in the listview of the Accounts it will show the all Accounts for the TEams I am a member of and all the Accounts for the Global Team

    How can I have it filter out all Accounts with the Global Team by default?

    So when I go int othe Accounts List view it will not have any Accounts with assigned team = Global, but if I need to find one I can just do a Search by Name,Number etc.

    Rgds
    Chris
    Linkedin Profile:Chris Lynch

    FDC IT Solutions
    FDC House
    Wellington Road
    Cork
    Ireland

  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: Help with filtering Accounts List View by Default

    You need to create a custom view.list.php for Accounts module.
    Inside the function display you need to add the team_id field into $_REQUEST if the search is empty.

    Cheers
    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
    chrislynch8's Avatar
    chrislynch8 is offline Sugar Community Member
    Join Date
    Oct 2007
    Location
    Cork, Ireland
    Posts
    747

    Default Re: Help with filtering Accounts List View by Default

    Hi André,

    Is there a template to work from, the deault view.list.php for the Accounts module I've looked and there isn't? I see that Project, Activities, Home, Calender have one, can I copy and edit them?

    Rgds
    Chris
    Linkedin Profile:Chris Lynch

    FDC IT Solutions
    FDC House
    Wellington Road
    Cork
    Ireland

  4. #4
    chrislynch8's Avatar
    chrislynch8 is offline Sugar Community Member
    Join Date
    Oct 2007
    Location
    Cork, Ireland
    Posts
    747

    Default Re: Help with filtering Accounts List View by Default

    Hi,

    I've copied over the view.list.php from the projects into the /custom/module/Accounts/views/

    I've made basic changes so now I have the same list view for Accounts as Default. Wherer in this file can I edit it to say only show Accounts that are NOT assigned the Global team.

    A line number, would do there are some many lines of code in the function display, I don't know where to start

    Rgds
    Chris
    Linkedin Profile:Chris Lynch

    FDC IT Solutions
    FDC House
    Wellington Road
    Cork
    Ireland

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 0
    Last Post: 2009-04-16, 03:34 PM
  2. Some default fields in Accounts List View not appearing after upgrade
    By ennsol in forum Installation and Upgrade Help
    Replies: 0
    Last Post: 2007-02-21, 10:11 PM
  3. Setting default list filtering?
    By ndaniels in forum Help
    Replies: 2
    Last Post: 2006-12-18, 01:33 PM
  4. Default Calendar List View
    By JHo in forum General Discussion
    Replies: 0
    Last Post: 2005-07-31, 03:39 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
  •