Another Account search issue

[piccirm2]

From the contact search form, if I try to pick up the parent account from the related account field the window popop to search account always return no items
the address on the popup is the following
127.0.0.1/sugarcrm/index.php?module=Accounts&action=Popup&mode=single &create=true&metadata=undefined

any explanation of this ???
Sugar CE 5.0.0c

[andopes]

Hi, piccirm2

Probably it is because a sql error.

If you understand programming edit the file include/ListView/ListViewData.php

add a

 echo "<LI>$main_query"; 
  

Just before it is searched into database, it is the its third place in file.
Perhaps there are issue in metadata.

[piccirm2]

Very usefutl hint !
Many tks

That's the result:
the difference of the search query with respect to the query of the accouts list view is that a left join condition on Accounts is missing causing an sql error in the query so that no records are retrieved

Now I have to understand why this happens ...

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.

I just answered this question in your other thread.

Best regards