ODBC Driver for SugarCRM

Build 24.0.9062

DropDownValues

The DropDownValues View. This view provides information regarding the values of dropdowns from different fields and modules.

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 module containing this dropdown item.
Field String The field containing this dropdown item.
ItemName String The name of the dropdown item.
DisplayLabel String The display label of the dropdown item.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062