How do i connect with field options table

Rohith MG
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
February 25, 2025

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!

Screenshot 2025-02-25 at 3.36.38 PM.png

ERD 

 

1 answer

0 votes
Pasam Venkateshwarrao
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
February 25, 2025

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

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
TAGS
AUG Leaders

Atlassian Community Events