location of Custom dropdown menus

[aheuermann]

I am looking where the data in dropdown menus is stored. Is it somewhere in the database or is it written to a file. I want to use a certain dropdown for a report. Does anyone know?

[kpit]

Admin -> Dropdown editor

[aheuermann]

Admin -> Dropdown editor

Not the editor, the actual table or file that contains the dropdown menus that are edited in the editor

[malcolmh]

Hi,

the values are written into the language file in the directory /custom/include/language/ i.e. en_us.php

Hope this helps

[Meyer]

ok, where do i find the dropdown values situated in reports - sugar professional?

[DragonflyMaster]

ok, where do i find the dropdown values situated in reports - sugar professional?

Hi,
if you are looking for a dropdown that is not a custom one, you should find its values here:
<sugar-root>\include\language\en_us.lang.php
values are stored in this form:

  'account_type_dom' =>
  array (
	'' => '',
	'Analyst' => 'Analyst',
	'Competitor' => 'Competitor',
	'Customer' => 'Customer',
	'Integrator' => 'Integrator',
	'Investor' => 'Investor',
	'Partner' => 'Partner',
	'Press' => 'Press',
	'Prospect' => 'Prospect',
	'Reseller' => 'Reseller',
	'Other' => 'Other',
  ),

in the example, values are listed as account_type_dom; you should look for the name of the dropdown that you are interested in.

[Meyer]

yip found them but they have no impact on report - sugar professional dropdowns

[DragonflyMaster]

yip found them but they have no impact on report - sugar professional dropdowns

What do you mean no impact on report?
Does it mean that you modified the values but you still see in report module the previous values?

[Meyer]

Correct

i have changed the label for accounts to broker network and contacts to broker contacts and oppertunities to sales activities.

everything works 100% until you have to create a custom report.

the firs dropdown shows the changed labels -but when you add related module you see accounts, contacts etc.

help

[DragonflyMaster]

Correct

i have changed the label for accounts to broker network and contacts to broker contacts and oppertunities to sales activities.

Have you made these changes everywhere in sugar or in a single module only?

everything works 100% until you have to create a custom report.

When the template is built, it takes sugar's defaults, not your changes.

the firs dropdown shows the changed labels -but when you add related module you see accounts, contacts etc.
help

If you get default labels adding a related module, it means that you haven't modified labels everywhere but for one or a few modules only. I suggest you make an in-file research for those labels you modified and change every occurence you find. After that use rebuild functions in Admin section.