MySql query to get list of tickets created in project in jira

[Neeta Dubey]

Hi,

Could some one please help me with mysql query to get list of tickets created in between last 6months with project name if possible.

[DPKJ · Accepted solution]

Here is your query that prints issue id, issue number, project key and project name (please note that visible issue key that we see is combination of project key and issue number, i.e. <PROJECT_KEY>-<ISSUE_NUMBER>)

SELECT i.id AS 'Issue ID',
i.issuenum AS 'Issue Number',
p.pkey AS 'Project Key',
p.pname AS 'Project Name'
FROM jiraissue i
left join project p
ON i.project = p.id
WHERE i.created > Date_sub(Now(), interval 6 month);

[Neeta Dubey]

Thanks! This is something I was looking for.

[Sebastian Krzewiński]

Hi @Neeta Dubey 

Everythin what you need you can find in jiraissue table. Project id/name/key you will find in project table.

Knowing both tables in database you can easily create proper select query to find issues.

Regards,

Seba