Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

JIRA SQL Query Help

abu zafar muyeen
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!
August 17, 2020

I want to join JIRA Issue with JIRA project Role. Also , i want to Join JIRAIssue table with CWD_membership table. Basically i want to get information on Jira Issues and Who in the project role involve and Child names.

THanks

Abu Muyeen

1 answer

0 votes
Daniel Eads
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
August 18, 2020

Hi Abu, welcome to the Community!

I see your question is tagged Jira Cloud. Is that the correct deployment type for you (example: the URL ends in atlassian.net)? If so, Atlassian Cloud sites don't provide access to the database to run SQL.

If this is a Server instance however, you do indeed have the capability to run SQL queries against the database. To be most helpful, can I know:

  1. What DMBS you're using (MySQL, Postgresql, Oracle, Microsoft SQL)
  2. Confirmation of the output you're looking for - multiple rows would be involved with listing the project roles but only one row per Jira issue in a standard join - can you provide the columns you're expecting to have and an example of the output you expect to see in each?

Cheers,
Daniel

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events