Results 1 to 6 of 6

Thread: Dropdows search

  1. #1
    timolein is offline Sugar Community Member
    Join Date
    May 2008
    Posts
    51

    Default Dropdows search

    Hi,

    Im lost. I need dropdown search field like below. How I can do that?

    Timo
    Attached Images Attached Images  

  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: Dropdows search

    Please, clarify you needs.

    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
    timolein is offline Sugar Community Member
    Join Date
    May 2008
    Posts
    51

    Default Re: Dropdows search

    Andopes,

    Accounts have their special products and those are entered when creating accounts. Now I need to search by product and there are like 30 products available. So if I can select one product from dropdown field and hit search I get all accounts who have this product.

    Timo

  4. #4
    timolein is offline Sugar Community Member
    Join Date
    May 2008
    Posts
    51

    Default Re: Dropdown search

    Any help with this issue ? Just a basic search field.. choose from dropdown, how to do this ?

  5. #5
    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: Dropdows search

    It is pretty possible but it requires php and sugarcrm development skills.
    What about your skills?

    You need to:
    1. Create a php script containing a class which extends the default Account class: custom/Modules/AccountListView.php;
    2. create a custom controller for Accounts (custom/modules/Accounts/controller.php);
    3. Implement into controller the method action_listview, which will redefine the bean attribute:

    PHP Code:
    function action_listview() {
      
    $this->view 'list';
      
    $this->bean = new AccountListView();

    4. Implement into AccountListView the method create_new_list_query which will override the $ret_array elements according to your needs, consider the products module when searching;
    5. Create an extended vardefs for Accounts where you will add a non-db dropdown fields containing the products dropdown
    6. Add this field into Accounts searchdefs.php
    7. Go to Admin -> Repair -> Rebuild Extensions

    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.

  6. #6
    timolein is offline Sugar Community Member
    Join Date
    May 2008
    Posts
    51

    Default Re: Dropdows search

    Thanks for this andopes, I will try to manage!

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Disabling Saved Search Select from Opening Advanced Search
    By tjdoyle00 in forum Developer Help
    Replies: 3
    Last Post: 2011-10-20, 03:07 PM
  2. Close Teb Search(Basic Search/Advance Search)
    By waree in forum Developer Help
    Replies: 1
    Last Post: 2008-12-27, 04:14 PM
  3. Replies: 0
    Last Post: 2008-08-21, 04:50 PM
  4. Replies: 4
    Last Post: 2008-04-03, 10:00 AM
  5. Replies: 2
    Last Post: 2006-05-06, 01:24 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
  •