DropDownValues
Provides field drop-down option definitions across modules. This view supports UI selection lists and ensures consistent controlled vocabulary values.
Table Specific Information
Select
When querying DropDownValues, you can create label fields for an existing dropdown list (which is tied to an existing module.) You can get these values simply by specifying the Module name (this is required):
SELECT * FROM DropDownValues WHERE Module = 'Accounts'
If you want to create a custom dropdown list, you can do so, however, the dropdown list needs to be tied to a custom field that belongs to the module, for instance:
SELECT * FROM DropDownValues WHERE Module = 'Accounts' AND Field = 'myCustomDropdown_c
Note that you may need to create a new custom field: Go to the Admin Panel > Studio > Accounts > Fields > Add Field.
Set type as Dropdown and set Drop Down List to the custom dropdown list you've created.
Columns
| Name | Type | Description |
| Module | String | The name of the SugarCRM module in which this drop-down item is defined. This value determines where the dropdown appears in the user interface and which records can use it. |
| Field | String | The field within the module that uses this drop-down item. This value establishes where the item is displayed and selected during record creation or editing. |
| ItemName | String | The internal name of the drop-down item. This value is stored in the database and is used for system logic, automation rules, and reporting. |
| DisplayLabel | String | The user-facing label that appears in the drop-down menu. This value provides the readable text that end users select when interacting with the application. |