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 ???


LinkBack URL
About LinkBacks



Reply With Quote
Bookmarks