How can i add new fields to my account search

[nicoageis]

Hi

I'm currently trying to customize the account tab.
So first, I added new fields which suit well my case. But now I try to change the fields of the search and I can't find the way to do it.
Any suggestions ? Is it possible ?

thanks

[Superman]

It is possible only if you are familiar w PHP and HTML.
There is no ability to create a search field through field layout

[nicoageis]

ok thank you for the answer.
I was looking for an easy solution but it looks like I'll have to get into the code.

[Rilliam]

Would that also imply that new custom fields are not searchable?

Made a Customer ID field and a Product ID field.
A customer ID field (number) is required by law in my country when sending bills.
The Product ID is so we can send the correct bills to the correct customers.

If we cant sort/search these, I am afraid Sugar is out...

[Superman]

When searching Suagr uses create_list_query() function, and in this function there is joins for custom fields included also.
So, you will have to edit 1-2 files to get it working.

[Rilliam]

I have absolutely no idea about the filestructure or editability of SugarCRM.
Care to give me tip as to what files and how to edit?
Willing to try...

[Superman]

The files are:
modules/Accounts/SearchForm.html
modules/Accounts/ListView.php

[Rilliam]

Ok, so basically in searchform I just add another TD with calls to my custom fields following this example

 <td class="dataLabel" noWrap><slot>{MOD.LBL_ACCOUNT_NAME}&nbsp;&nbsp;<input type=text tabindex='1' size="10" name="name" class=dataField  value="{NAME}" /></slot></td> 
  

and a new query following this example in listview.php

 if (isset($_REQUEST['website'])) $website = $_REQUEST['website']; 
  

and inside the array part of the code.
I see that goes in four places, two for query and push_array and then one for main form and one for advanced...I think

Hmm, better triplecheck the base for correct field names...

ill get back.

[Superman]

Actually, custom fields have another names (like {some_custom_file_name_c}), you can find your custom field in DB-table fields_meta_data.

[stevec]

If I understand the question correctly, you can add search fields - certainly to advanced search page, and also to the basic search page but it may be harder to label.

Go to field layout in admin, select 'edit in place', then browse to the account page. The search panel will have an edit icon next to it which allows you to remove, edit and add criteria.