Search results - parent name instead of Account name

[Billwobo]

I put the "member of" name (parent name) field in my Account list. When I search the list with the Account name, it searches the parent name instead of the Account name.

It's not a big bug. I removed the parent name from the list and now it's fine. But it would be useful to me to show parent name in the list.

I'm running 5.1RC.

Anyone knows a solution?

[ptemplin7]

Have you checked the bug list for this? Sound like it should be a bug if it isn't parsing the name correctly to use the account name not the parent name.

Report it if it isn't listed,
Paris


PS Make sure it reproducible.

[enrashid]

I put the "member of" name (parent name) field in my Account list. When I search the list with the Account name, it searches the parent name instead of the Account name.

It's not a big bug. I removed the parent name from the list and now it's fine. But it would be useful to me to show parent name in the list.

I'm running 5.1RC.

Anyone knows a solution?

This was a bug in d release, but was fixed in e release and some other post said that it was broken again in either the f release or RC. Submit a bug report for this if one is not already submitted because this is a big deal if you cannot search on an account with a parent.

[aewatkins]

This was reported as a bug, but I'm wondering if anyone knows how to fix this manually. Please? We're on 5.0.0f Professional trying to get Sugar rolled out. Not impressive to management that they can't search properly. We really would like to have the Parent Company in the list view if possible. It does work if we remove the Parent Comany from the List View though.

Help if you can - please?!? Thanks in advance!

[niccl]

I 'fixed' this by commenting out a line in data/SugarBean.php. In my bersin (5.1b) it's line 3231. details:
//Replace references to this table in the where clause with the new alias
$join_table_name = $this->$data['link']->getRelatedTableName();
#### NCL fix: comment out the following line ###
# $where = preg_replace('/(^|[\s(])' . $join_table_name . '\./', '${1}' . $params['join_table_alias'] . '.', $where);
if(!$table_joined)
{
$joined_tables[$params['join_table_alias']]=1;
$joined_tables[$params['join_table_link_alias']]=1;
}
$jtcount++;

I dion't guarantee it's a complete fix, but I haven't yet found a case that this fix breaks