Help with db query

Question

I need a query to tell me the following;

count of tickets, where assignee = person1 and date between date1 and date2

Grouped by year/month

Which tabels to I need for that? and, can someone help me with the actual query?

(the built in reports does not give me more than a year)

Alexey Matveev · Accepted Answer

Hello,

You should query the jiraissue table.

Use assignee and created fields.

Shimshey Rosenberg · Accepted Answer

Thanks!! I have successfully queried the db!

Here is an example code for reference.

--

Select count(ID), Year(created), Month(created)
From jiraissue
Where project = 1120 and assignee = 'user'
Group BY YEAR(created), Month(created)