Unable to retrieve a custom_field value label from the database

quang.ha-minh

I'm trying to get a custom_field value label.
From the table 

issue_multiselect_history

I'm able to see my value (107)

But I cannot find it in the table 

field_option

Therefore I'm not able to retrieve the label behind the value (107).
This custom_field is used to link a Jira ticket to an organization.

Marc -Devoteam-

Hi @quang.ha-minh 

Welcome to the community.

Be addressing that you are able to query the Jira DB, my assumption is that you are not on Jira Cloud, but on server or Data Center

The Jira Rest API should help you out here.

If you do run Jira Service Management Cloud, you can use the following form the JSM Cloud Rest API

https://developer.atlassian.com/cloud/jira/service-desk/rest/api-group-organization/#api-rest-servicedeskapi-organization-get

If you are on server/DC, then use the following Rest API

https://docs.atlassian.com/jira-servicedesk/REST/5.11.0/#servicedeskapi/organization-getOrganizations