Results 1 to 3 of 3

Thread: Account search wrong field mapping

  1. #1
    piccirm2 is offline Sugar Community Member
    Join Date
    Apr 2008
    Posts
    65

    Default Account search wrong field mapping

    Hi

    by echoing the output query of the basic search panel I found that the name field correspond to the parent_name
    I tryed a like 'aaaa' search with enhanced search plugin

    SELECT accounts.id , accounts_cstm.* ,
    jt0.name account_name , jt0.assigned_user_id account_name_owner ,
    'Accounts' account_name_mod, accounts.account_type , accounts.name , accounts.billing_address_city ,
    jt1.user_name assigned_user_name , jt1.created_by assigned_user_name_owner ,
    'Users' assigned_user_name_mod, accounts.assigned_user_id
    FROM accounts LEFT JOIN accounts_cstm ON accounts.id = accounts_cstm.id_c
    LEFT JOIN accounts jt0 ON jt0.id= accounts.parent_id AND jt0.deleted=0 AND jt0.deleted=0
    LEFT JOIN users jt1 ON jt1.id= accounts.assigned_user_id AND jt1.deleted=0 AND jt1.deleted=0
    where ((jt0.name like '%aaaa%')) AND accounts.deleted=0 ORDER BY account_name ASC

    How can I fix this problem having name to correspond to the account name and NOT parent_name ???

  2. #2
    clint's Avatar
    clint is offline Sugar Team Member | Forums Lead Moderator
    Join Date
    Aug 2004
    Location
    Silicon Valley
    Posts
    2,120

    Default Re: Account search wrong field mapping

    Since this is an issue with the Enhanced Search module, I suggest posting in the forums specific to that project.
    Sugar Developer Zone - developer resources | Sugar University - user and admin training
    Sugar Docs - user and admin documentation |
    Sugar Bug Tracker - Enter or view bugs
    SugarForge- open source modules, themes, lang packs | SugarExchange - commercial extensions

    Clint Oram
    Chief Technology Officer and Co-founder
    SugarCRM

  3. #3
    piccirm2 is offline Sugar Community Member
    Join Date
    Apr 2008
    Posts
    65

    Default Re: Account search wrong field mapping

    the issue was previous to the enhanced search install
    I have installed it in order to make like search as a debugg tool

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. use custom field account to search contact in target list
    By Beranrdi in forum Developer Help
    Replies: 9
    Last Post: 2010-07-30, 04:12 AM
  2. Replies: 0
    Last Post: 2008-04-16, 06:27 AM
  3. Custom search in Account Popup
    By jungler in forum Developer Help
    Replies: 0
    Last Post: 2008-04-14, 01:00 AM
  4. BUG In Search/Edit Layout???
    By tj@estreet.com in forum Help
    Replies: 13
    Last Post: 2006-06-10, 05:43 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
  •