Global Search Doesn't look for account numbers

💬 General Discussion
1

Hi.
7.4.3
All the accounts we import into the Accounts Module have an account number. This is a unique number.

BUT, when we search on the Global Search at the top right of the screen it does not pick up any account numbers, it picks up account name, but it will not find any account numbers?

The Account Number is a Custom Field in the accounts module and is an integer field.

Is it because it’s a custom field?
How do I get Search to look at this?

2

I found this for Sugar?
http://developer.sugarcrm.com/2011/04/29/howto-add-custom-fields-into-the-global-search/

Do I need to do this?

3

Well… I tried that and it didn’t work :frowning:

So i’m pretty much still stuck at square one. It didn’t have any errors, but It just doesn’t add the fields to the search

4

:/srv/www/htdocs/custom/Extension/modules/Accounts/Ext/Vardefs # more sugarfield_wg_accountnumber_c.php (EDITED as it wasn’t showing the data below)

See attached file as it won’t show this up correclty?

it had the two existing lines, so I added the third one for the search.

I also went to :/srv/www/htdocs/custom/modules/Accounts/metadata # SearchFields.php and added the 4 lines beginning with wg_accountnumber_c to Searchfields.php

<?php // created: 2016-01-26 15:44:33 $searchFields['Accounts'] = array ( 'name' => array ( 'query_type' => 'default', ), 'wg_accountnumber_c' => array ( 'query_type' => 'default', ), .... I then did a rebuild. I went into an account and changed who owned the account as I thought that was changing it and making it save again? Then tried a search and it couldn't see the account number
5

Hello again, everyone. Sorry to be a real big pain in the backside. But this is soooo frustrating. I’ve included a screenshot of my field and as far as I can see i’ve done everything right.

Ran repair / rebuild. After Gone into a specific Account and changed one of the fields and saved the file again.
But I still cannot search at the top on the Account Number.

The screenshot shows:-
the field in the /customer/Extension/modules/Accounts/Ext/Vardefs directory.
the existing SearchFields.php file for Accounts in /custom/modules/Accounts/metadata with my field added to the end of the file.
It also shows just how the field looks within the accounts module within suitecrm.

I cannot see what i’ve done that is different to the advice on the various other threads including… https://suitecrm.com/community/suitecrm-7-0-discussion/5661-enable-custom-field-global-search

Any help would be greatly appreciated.

6

Hi.

OK So the StandardSUITECRM Search it works :slight_smile:

BUT It doesn’t work with the Use AdvancedOpenDiscovery Search?

Can I change it so it doesn’t use the advanced search by default Until I read up on the AOD Search and work out if / how to get that working

Unticked use AOD and that work.

Is there a way to get it working within AOD?