JIRA SQL Query Help

[abu zafar muyeen]

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

[Daniel Eads]

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