Query Jira database to find the number of tickets closed for particular project

[Rajesh Kappa]

Pleaase help me with Query Jira database to find the number of tickets closed for particular project per category per month from aug 2017 through Jan 2018.

[Danyal Iqbal]

Why do you want to query the db? Why not use JQL/advanced search?

Goto Issues>Search for issues and use the following jql:

project = projectName  AND created <= "2018-01-01" AND created >= "2017-01-01" order by created

[Alexey Matveev]

Why you do not want to use Jira Rest Api. You could execute a jql query with GET /rest/api/2/search and get all the issues. You can read more here:

https://developer.atlassian.com/cloud/jira/platform/rest/#api-api-2-search-get