Account Search problem

[piccirm2]

Hi

if I try to search an account using "name" field it seems that it correpsond to another field "member of"
I get this suspect after installing enhanced search plugin and performing some "like" search.
also with billing city search I get some not explained behavior
How can I debug this problem ? how does the search function work ?

In the demo site of sugar it works (so it's not a bug)
I have CE 5.0.0c version

[piccirm2]

tks to andopes I was able to debugg....

I've also understood why in the Account basic seach form when I seach for name I get wrong results: because the field called name in the Studio during the editing of the search panel in the parent_name account !
The question is: where these mapping between table column and sugar filed name is done in order to fix it ???

[andopes]

Hi.
They are in the metadata modules/YourModule/vardefs.php
Or if they are extended vardefs in custom/Extension/modules/YourModule/Ext/Vardefs/vardefs.ext.php

Cheers

[piccirm2]

I've found in the Account vardefs.php

'account_name' =>
array (
'name' => 'account_name',
'rname' => 'name',
'id_name' => 'account_id',
'vname' => 'LBL_MEMBER_OF',
'type' => 'relate',
'table' => 'parent_accounts',
'isnull' => 'true',
'group'=>'parent_name',
'module' => 'Accounts',
'massupdate' => false,
'source'=>'non-db',
'len' => 36,
'link'=>'member_of',
'unified_search' => true,
'Importable' => false,
),

even if i haven't changed it, 'vname' => 'LBL_MEMBER_OF', it's quite strange
But I couln't find LBL_MEMBER_OF label in the language definition file

In addition in the vardfes I do not see, for example, other fields like city (for which also I have problems)
there's something that I not understanding...

[LiveDPI]

I am having this same issue, and although I find the same variable definition array as noted above, I am not clear on what the values *should* be in order to get the search to work. Can anyone provide some insite please?

[kenshiro]

Hi Piccirm,
sorry if I'm replying so late but I thought you've said that your problem wasn't due to Enhanced Search on this thread .
Did you try to uninstall Enhanced Search and search again ?

Enhanced Search doesn't affect vardef files, anyway.

[piccirm2]

Since I have not made too much modifications, I have reinstalled a new sugar istance and I have made customization to account module paying attention not to add any parent_name in the list view.
So the issue remains unsolved and it's not due to enhanced search
tks

[LiveDPI]

Hey everyone. I was having this issue from both Professional and Enterprise edditions. I just upgraded both of those instances to 5.0.0e and now the account name search works GREAT! No more problems! Yay!