SQL Query to fetch all issues from specific project

Question

Dear Experts,

I want to fetch all issues details (Issue Key, Project, Project Key, Summary, Reporter, Created Date, Resolution date, Status, XYZ) from specific project created between 1st Jan 2025 to 31st Jan 2025 along with Cascaded custom field value.

Project: ABC

Cascaded Field: XYZ (XYZ1, XYZ2)

XYZ1 : Asia, Europe

XYZ2 for Asia : India, Japan, China

XYZ2 for Europe: Germany, Sweden

Could you please help me to get correct query.

Bindu Nikam-Deshpande · Answer

Hi @RG

Can you please try this query and check the result

SELECT

IssueKey, Project, ProjectKey, Summary, Reporter, CreatedDate, ResolutionDate, Status, CascadedFieldValue

FROM

IssuesTable

WHERE

Project = 'ABC'

AND CreatedDate BETWEEN '2025-01-01' AND '2025-01-31'
AND (CascadedFieldValue IN ('Asia', 'Europe', 'India', 'Japan', 'China', 'Germany', 'Sweden'));

Explanation of the query:

Cascaded Custom Field Filter: Filters the values for XYZ (both XYZ1 and XYZ2) based on your hierarchy.

Make sure to update the table name (IssuesTable) and column names (CascadedFieldValue, etc.) based on your database structure.

Jim Knepley - ReleaseTEAM · Answer

Hi @RG

If you're looking for  SQL queries, and that's not a typo in the subject, you can see the SQL schema here: https://developer.atlassian.com/server/jira/platform/database-schema/

You're probably going to use these tables:

* jiraissue

* project

* customfield

* customfieldvalue

RG_0m27n8 · Answer

Hi @Aaron Pavez _ServiceRocket_  Thanks for your help. I am looking for DB query to fetch all records from specific project.

JQL not allowing me to fetch more than 2000 records and we have more than 100k records for each Cascaded values.