How do i connect with field options table

[Rohith MG]

Hello Folks,

I am using the Jira cloud version and am trying to join the field option table to retrieve the values for each custom field created. This is to create a report of all tickets after extracting & loading the data into the database. The ERD diagram & screenshot show that it is not possible to join. Has anyone this issue & found a solution? Please let me know

Thanks!

ERD 

[Pasam Venkateshwarrao]

Hi @Rohith MG 

Thanks for reaching out to the community.

Elements connect allows you to configure connected fields which pull data from external datasources. You can also configure dependencies between those connected fields, such as display specific information about the customer selected. For example, if your customer is tagged as "active" in your external datasource, you can easily configure that in connected fields.

Try this app it is free App and there are some paid Apps also is there 

https://marketplace.atlassian.com/apps/1232142/elements-connect-helper-for-custom-fields-integration?tab=overview&hosting=cloud