Provides field dropdown option definitions across modules. This view supports UI selection lists and ensures consistent controlled vocabulary values.

Table Specific Information

Select

The add-in uses the SugarCRM API to process WHERE clause conditions that are built with the following columns and operators:

• Module supports the = comparison operator.
• Field supports the = comparison operator.

When querying DropDownValues, you can retrieve label values for an existing dropdown list associated with a module. To return these values, specify both the Module name and the Field that contains the dropdown item (both are required).

The following query is processed server-side:

SELECT * FROM DropDownValues WHERE Module = 'Accounts' AND Field = 'myCustomDropdown_c

If you want to create a custom dropdown list, it must be linked to a custom field that belongs to the module.

Note: If necessary, create a new custom field by navigating to Admin Panel > Studio > Accounts > Fields > Add Field.

Set the field type to dropdown, and create or select the custom dropdown list.

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.