JQL for Created vs Resolved

[Jeniffer Kamaraj]

Hi team, 

Can I know the JQL for Created vs Resolved in a month for multiple project? Or single project

[Walter Buggenhout · Accepted solution]

Hi @Jeniffer Kamaraj,

There is not really a JQL for created vs resolved. What you can do, is add a created vs resolved gadget on a Jira dashboard and simply add a Jira project as the source for the gadget.

This will then display issues created and resolved lines on the chart, based on the created and resolved dates of the issues in your project.

Instead of a single project, you can also add a filter as the gadget source. Again, that should only include the list of projects you want to report on. The gadget takes care of the rest.

Hope this helps! 

[Jeniffer Kamaraj]

Okay this helps . 

But if i want to do filter for single project, may I know the JQL if I pull out within a month data ?

[Walter Buggenhout]

Suppose you want to pull all issues that were created or resolved during the previous month, you can do something like this:

(created >= startOfMonth(-1) AND created <= endOfMonth(-1)) OR
(resolved >= startOfMonth(-1) AND resolved <= endOfMonth(-1))

But, honestly, that filter will do nothing but give you a list of issues. The chart allows you to group the data by day / week / month / quarter or even year, like this:

[Jeniffer Kamaraj]

Thanks! Helps alot

[Natalia_Kovalchuk_SaaSJet_]

Hi @Jeniffer Kamaraj,

Unfortunately, Jira's native JQL can't show you the difference between "Created" and "Resolved" issues in one query, because JQL just pulls up lists of issues, not stuff like counts or trends. However, you can look for issues that were created or closed in a certain time frame by running two different queries, such as:

project in (PROJ1, PROJ2) AND created >= startOfMonth() AND created <= endOfMonth()

project in (PROJ1, PROJ2) AND resolved >= startOfMonth() AND resolved <= endOfMonth()

If you want a better and quicker way to view created and resolved issues from multiple projects in Jira for a specific period, I suggest using the Issue History for Jira app from SaaSJet. It shows you how issues progress over time.

Also, using this app, you can export all the needed data in CSV or Excel.