How do I search customized fields in Sugar?

[pnowakiris]

Does anyone know how to search customized fields in any of the modules? I am using Sugar Open Source and it doesn't seem to have any reporting capabilities. Is there something I need to install to make this happen?

Any help would be appreciated.

[SamuelAugy]

You can see zucker reports.

[andopes]

Hi, pnowakiris.

You can find all custom fields for a module at the Studio at Admin guide.
Just go to: Admin -> Studio -> Edit a Module -> YourModule -> Edit Custom Fields -> View Custom Fields.

You can also find them into database at the table fields_metadata:

SELECT * FROM fields_metadata WHERE custom_module = 'YourModule'

Cheers.

--
André Lopes
Lâmpada Global Services
Rua Bela Cintra, 299 conjunto. 51
São Paulo, SP 01415-000
tel1. 55 11 3237-3110
cel. 55 11 7636-5859
e-mail: info@lampadacrm.com.br

[kuske]

You can add them to the search form of each module in
admin - studio - edit a module - <module> - edit layout - search form

hk

[rexavh]

Is it possible to use global search to find data in custom fields?

[PointedEars]

You can add them to the search form of each module in
admin - studio - edit a module - <module> - edit layout - search form

Hello,

if I may jump in here, I think I have a related problem: I have created three custom modules, named Categories, Functions, and Groups. Each of these is related to Contacts (OOB). I need to enhance the Advanced Search form of the Contacts module so that the user can select one or more of each related objects as search parameter. So that the search result only yields the Contacts which are assigned the respective Categories, Functions, and Groups.

But since Studio does not seem to allow to add related fields to the search form, how should I go about this? It is the first time I am developing on SugarCRM (5.0e CE). All hints are greatly appreciated.


Regards,

PointedEars

[mem94566]

I want to concur, that I can NOT get search results using custom fields in LEAD, or ACCOUNT.

I have a custom field called 'repcompany_c', and the display test of REP COMPANY. When I enter into for an EXACT match of any REP COMPANY, i.e. "ABC", I get no search results. Is this a "FEATURE" or a "MISTAKE" in query code ?

Best !

Martin