Results 1 to 7 of 7

Thread: Add a related field in the contact module like is done in the task module

  1. #1
    jejeman is offline Sugar Community Member
    Join Date
    Jan 2012
    Posts
    49

    Default Add a related field in the contact module like is done in the task module

    Heloo,

    I use sugar v6.5.14
    In the task module, in the advanced search, there is a filed "related to" for selecting another module and you can filter by type a name.
    I want to have the same feature on the contact module in the advanced search.
    How I can do that ?
    Thank you.

  2. #2
    jejeman is offline Sugar Community Member
    Join Date
    Jan 2012
    Posts
    49

    Default Re: Add a related field in the contact module like is done in the task module

    Anybody can give me a track ?

  3. #3
    davidboris's Avatar
    davidboris is offline Sugar Community Member
    Join Date
    May 2010
    Posts
    1,525

    Default Re: Add a related field in the contact module like is done in the task module

    Hello,

    Have you created the Flex relate type field in Contacts module? Because I created a flex relate field in Contacts module and got it placed on Advance Search. Everything said was done from Admin > Studio.
    Web : http://www.urdhva-tech.com
    Twitter : @urdhvatech
    Email : contact@urdhva-tech.com
    Blog : Urdhva-Tech
    Skype : urdhvatech

    Our Premium Projects for SugarCRM:
    Premium theme for SugarCRM CE (Community Edition 6.5+ with 4 combinations, Black + Orange/Red/Green/Blue, bootstrap3 based)
    Duplicate detector to avoid duplicate data entry.
    Customer Self Service Portal for All Flavours.
    tagMe A complete tag management for SugarCRM.
    Meeting Map Reminder Meeting reminder with Gmap in Email

  4. #4
    jejeman is offline Sugar Community Member
    Join Date
    Jan 2012
    Posts
    49

    Default Re: Add a related field in the contact module like is done in the task module

    Thank you for your advice, Now I can create a relate field in the contact advanced search
    But a problem remain : when I select a project name and do the search sugar find any contacts.
    I take a look in the log for the query and I see sugar search in the table contacts_cstm instead of the table projects_contacts
    Because when I add a contact in a project, sugar add a line in the table projects_contacts not in the table contacts_cstm
    Is it possible to change that ?
    Thank you.

  5. #5
    davidboris's Avatar
    davidboris is offline Sugar Community Member
    Join Date
    May 2010
    Posts
    1,525

    Default Re: Add a related field in the contact module like is done in the task module

    Thats not the solution for what you are looking for.. You want to filter list by its related items(which are actually many-to-many).. Flex relate field is meant for a unique related module and unique related id for a record.

    Sorry I dont have a prompt solution for what you are looking for, as soon as I know, I will drop comment here.
    Web : http://www.urdhva-tech.com
    Twitter : @urdhvatech
    Email : contact@urdhva-tech.com
    Blog : Urdhva-Tech
    Skype : urdhvatech

    Our Premium Projects for SugarCRM:
    Premium theme for SugarCRM CE (Community Edition 6.5+ with 4 combinations, Black + Orange/Red/Green/Blue, bootstrap3 based)
    Duplicate detector to avoid duplicate data entry.
    Customer Self Service Portal for All Flavours.
    tagMe A complete tag management for SugarCRM.
    Meeting Map Reminder Meeting reminder with Gmap in Email

  6. #6
    jejeman is offline Sugar Community Member
    Join Date
    Jan 2012
    Posts
    49

    Default Re: Add a related field in the contact module like is done in the task module

    Thank you for your answer.
    I take a look how query on account are done in contact search and I success reproduce this feature for project. and now it works !
    thank you !

  7. #7
    asavaliya is offline Sugar Community Member
    Join Date
    Nov 2010
    Posts
    101

    Default Re: Add a related field in the contact module like is done in the task module

    Hi...Jejeman
    It is possible to do search it.
    You need to put non-db field in listviewdefs and then do subquery on it in SearchFields.php.
    Just like email or sync_contact field in SearchFields.php in Contact Module

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 3
    Last Post: 2011-12-01, 11:06 PM
  2. Replies: 2
    Last Post: 2011-04-25, 09:02 AM
  3. Replies: 0
    Last Post: 2008-10-20, 10:55 AM
  4. Replies: 1
    Last Post: 2008-06-16, 02:01 PM
  5. Add contact select field to task module
    By nbuffo in forum Help
    Replies: 1
    Last Post: 2007-09-11, 06:30 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
  •