Create
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Products
See all
Community resources
Top groups
Explore all groups
Community resources
Learn
Community resources
Events
Community resources

Multiple left joins to get to a custom field

Mary Coakley
Mary Coakley June 17, 2022

Struggling with the multiple left joins to show a custom field. Has anyone done this already that I can steal it? :)

 

 

Answer
Watch
Like Be the first to like this
239 views

1 answer

1 accepted

0 votes
Answer accepted
Kurt Klinner
Kurt Klinner
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.
Get recognized
June 17, 2022

@Mary Coakley 

 

Hi Mary

what are you trying to retrieve. Custom fields used in a project, values of a custom field etc?

 

Cheers

Kurt

View More Comments
Mary Coakley
Mary Coakley June 21, 2022

I'm trying to pull the value for a custom field matching to the jira issue. Currently joining to jira issue, customfield value, custom field option and custom field. 

Like
Kurt Klinner
Kurt Klinner
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.
Get recognized
June 22, 2022

Can you share your current query?

Like
Reply

Suggest an answer

Log in or Sign up to answer
Jira
Jira Software
TAGS
AUG Leaders

Atlassian Community Events

    See all events