JQL filter to see tickets closed in certain projects over last 2 days?

[Amy Blower]

Hi all, I need to create a filter to show tickets closed on two specific projects in the past two days and not all current running projects - thanks!

[Max Foerster - K15t]

Hey @Amy Blower , welcome to the community! :)

There's a really good documentation about JQL available in the official docs, which explains all functions, fields, operators, etc. It's perfect for everyone who wants to dive deeper into building JQL queries. You should definitely check it out:

• Use advanced search with Jira Query Language (JQL) 

And now, to your question: what is the challenge for you here? You know the specific projects, right? So start building your query:

project in (Project1, "Project 2", .....) AND

And when you close issues, do you have different statuses that you want to look at and are you also setting a resolution in these statuses? You could try something like this:

resolved >= startOfDay(-2)

Meaning the issues were resolved between the start of the day two days ago and now. Was that already helpful?

Best, Max

[Bill Sheboy]

Hi @Amy Blower -- Welcome to the Atlassian Community!

Yes, and...to Max's answer:

There is some free, online training from Atlassian on learning how to answer such questions with JQL.  Please look here for a great example class: https://university.atlassian.com/student/path/849533-gain-project-insights-through-jql

Kind regards,
Bill

[Tom Lister]

Hi @Amy Blower 

Depending on what you define as closed, you can do something like this:

project in (SSP,DT1) and resolved >= -2d

[Vedant Kulkarni_Trundl]

@Amy Blower please try something similar to this

project in ("Project2", "Project2") and resolutiondate >= startOfDay(-2)