Hi, All

I am using sugar 5.0a and I have problem with global search with the Cases module. All the other module work properly, but if I tick 'cases' it will generate a SQL Error : The multi-part identifier "accounts.name" could not be bound. I looked at the log file and found the wrong query is

SELECT TOP 31 cases.id, cases_cstm.*, cases.name, cases.priority,
jt0.user_name assigned_user_name, jt0.created_by assigned_user_name_owner,
'Users' assigned_user_name_mod, cases.assigned_user_id , cases.status , cases.assigned_user_id
FROM cases
LEFT JOIN cases_cstm ON cases.id = cases_cstm.id_c
LEFT JOIN users jt0 ON jt0.id= cases.assigned_user_id AND jt0.deleted=0 AND jt0.deleted=0
where ((cases.case_number in ('-1') or cases.name LIKE '%test%'
or accounts.name LIKE '%test%'
))
AND cases.deleted=0

I did some customization in the cases module and all that ive done is just creating a relationship between project and cases, and hide the accounts from case views, but I didnt change the vardefs file in cases module. Why is there "accounts.name" in the query? If I delete accounts.name like '%test%' the query returns the result as expected but how can I get of rid of this condition?

In addition, I renamed module 'Cases' to 'Issues', but how can I change the name in the global search?

Thanks for your help.