Results 1 to 3 of 3

Thread: Search by any record field

  1. #1
    dcornford is offline Sugar Community Member
    Join Date
    Jan 2012
    Posts
    14

    Default Search by any record field

    Hi everyone

    My Sugar (Community Edition) seems to be only searching for matches in the 'Name' field, meaning that my sales team can only search for the 'Names' of companies, but any other search attempt (the company's product name or brand name in those custom fields) will not work and no results are returned.

    How do I enable Sugar so that I can search for information in any field? (i.e. if a lead has a company name of 'Brandx' and a product of 'killer iphone application' I can put either Brandx or killer iphone application into the search field and it will return a result of the lead with this data in the relevant fields).

  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: Search by any record field

    You can use the global search instead, it is pretty easier to customize.

    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
    dcornford is offline Sugar Community Member
    Join Date
    Jan 2012
    Posts
    14

    Default Re: Search by any record field

    Thanks Andopes

    I saw the posts in the thread: Enabling global search for custom fields and modules

    This seems to say that I need to create this 'search.php' file in each module that has the custom field that that I want to search for. Is this correct?
    I have the custom field 'App Title', so I am reading this that I have to create the search.php in all modules that contain this custom field and the PHP code would be the following (this is an example of the PHP code for the leads module):
    $dictionary['LEADS']['fields']['FIELD']['rname'] = 'apps_title_c';
    $dictionary['LEADS']['fields']['FIELD']['vname'] = 'LBL_APP_TITLE';
    $dictionary['LEADS']['fields']['FIELD']['type'] = 'relate';
    $dictionary['LEADS']['fields']['FIELD']['dbType'] = 'varchar';
    $dictionary['LEADS']['fields']['FIELD']['table'] = 'table_cstm';
    $dictionary['LEADS']['fields']['FIELD']['unified_search'] = true;

    This is where the Field Name = apps_title_c and the System Label = BL_APP_TITLE

    Can you let me know what I will have to do to add multiple custom fields to the global search.

    Hope that you can advise if this is correct and then I'll get started!

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. basis search - record broken
    By peppolax in forum Help
    Replies: 3
    Last Post: 2010-02-12, 08:52 AM
  2. Replies: 2
    Last Post: 2009-05-22, 12:04 PM
  3. Total of a record field in Search View.
    By KingoftheRoad in forum Developer Help
    Replies: 5
    Last Post: 2009-01-06, 04:53 AM
  4. Replies: 4
    Last Post: 2008-04-03, 10:00 AM
  5. Replies: 2
    Last Post: 2006-12-20, 08:15 AM

Tags for this Thread

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
  •