Results 1 to 2 of 2

Thread: Cross module Search

  1. #1
    ramji123 is offline Sugar Community Member
    Join Date
    Nov 2006
    Location
    Bangalore, India
    Posts
    266

    Default Cross module Search

    Hi,

    I am using Sugar4.5.1f pro version.

    In search, we can't search Cross Module?

    My requirement is :

    I am searching the subject field in case module, it will search only case module. but i need these field also search in Notes table.

    Is it possible?

    Ramji

  2. #2
    dlorenzetti's Avatar
    dlorenzetti is offline Sugar Community Member
    Join Date
    Jan 2008
    Location
    São Paulo, Brasil
    Posts
    189

    Default Re: Cross module Search

    Hi Ramji,

    You can put the informations in modules/Cases/metadata/SearchFields.php and modify the array "$searchFields['Cases']" in name.

    like that:

    'name' => array( 'query_type'=>'default','db_field'=>array('cases.n ame', 'notes.name')),

    and the ListView going to build the query like that:

    WHERE cases.name like '<search>%' OR notes.name like '<search>&'

    but you need to have a relationshp between cases and notes, else the query going to return empty because it don't find the table notes.


    Cheers,
    Diego Lorenzetti
    Lampada Global Services - Open Source Solutions
    Phone: +55 11 3237-3110
    Email: equipe@lampadaglobal.com
    Site: www.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.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Need help with search field in custom module dashlet
    By bstonehill in forum Developer Help
    Replies: 0
    Last Post: 2008-07-03, 02:15 PM
  2. Replies: 0
    Last Post: 2008-06-29, 11:27 PM
  3. Creating new Module in 5.0c
    By jlabuelo in forum Help
    Replies: 2
    Last Post: 2008-04-17, 09:58 AM
  4. Replies: 0
    Last Post: 2007-01-16, 05:27 PM

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
  •