Where Can I Find the Values of Custom Drop-Down Fields in My Destination?

Question

Where can I find the values of a custom drop-down field in my destination?

Environment

Connector: Jira

Answer

The values for the drop-down field can be found in the FIELD_OPTION table.

You can join the ISSUE table with the ISSUE_<FIELD>_HISTORY and FIELD_OPTION tables in your destination.