Dropdows search

[timolein]

Hi,

Im lost. I need dropdown search field like below. How I can do that?

Timo

[andopes]

Please, clarify you needs.

Cheers

[timolein]

Andopes,

Accounts have their special products and those are entered when creating accounts. Now I need to search by product and there are like 30 products available. So if I can select one product from dropdown field and hit search I get all accounts who have this product.

Timo

[timolein]

Any help with this issue ? Just a basic search field.. choose from dropdown, how to do this ?

[andopes]

It is pretty possible but it requires php and sugarcrm development skills.
What about your skills?

You need to:
1. Create a php script containing a class which extends the default Account class: custom/Modules/AccountListView.php;
2. create a custom controller for Accounts (custom/modules/Accounts/controller.php);
3. Implement into controller the method action_listview, which will redefine the bean attribute:

 function action_listview() {
  $this->view = 'list';
  $this->bean = new AccountListView();
} 
  

4. Implement into AccountListView the method create_new_list_query which will override the $ret_array elements according to your needs, consider the products module when searching;
5. Create an extended vardefs for Accounts where you will add a non-db dropdown fields containing the products dropdown
6. Add this field into Accounts searchdefs.php
7. Go to Admin -> Repair -> Rebuild Extensions

Cheers

[timolein]

Thanks for this andopes, I will try to manage!