Results 1 to 3 of 3

Thread: Create query on a field in other module

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

    Default Create query on a field in other module

    Hello,

    On the contact search, I can search on any contact's attributes.
    On the account search, I can search on any account's attributes.
    And there is a relationship on the 2 entities, a Contact works in an Account.
    Now I want to add a feature to do a query on the Contact search with a Account attribute.
    For example, I want to search all contact who works in an Account which is the state CA.
    How i can do that ?
    Thank you.

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

    Default Re: Create query on a field in other module

    Hi..
    Please check SearchFields.php which has sub-query for favorites and sync_contact for Contact Module

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

    Default Re: Create query on a field in other module

    Thank you for your answer.
    I found how to create a new fields and a subquery in the searchfields.php
    But the user must type the name of the state in the field. Is it possible to replace the empty field by a dropdown field ?
    Thank you.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 1
    Last Post: 2013-01-23, 09:42 AM
  2. Replies: 0
    Last Post: 2010-03-25, 03:08 PM
  3. Replies: 6
    Last Post: 2010-03-24, 10:36 AM
  4. Replies: 6
    Last Post: 2010-03-05, 12:38 PM
  5. Replies: 2
    Last Post: 2008-08-21, 09:18 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
  •