The Atlassian Community Forums are currently in read-only mode. We will be relaunching on a new platform on September 22 (read more here). We apologize for the extended downtime. For concerns or questions, please email communitymanagers@atlassian.com. See you on the other side, on the new Atlassian Community Forums! :)

×

Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

Information about JQL

Ataib Ahmad
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
March 22, 2021

Hi, how can I get JQL if I want to know that how many specific tickets are closed by a specific account?

1 answer

Comments for this post are closed

Community moderators have prevented the ability to post new answers.

0 votes
Esther Strom
Community Champion
March 22, 2021

Hi, @Ataib Ahmad - welcome to the Community!

JQL isn't like SQL; you can't run a COUNT query that returns a number. What you can do is run a query that will return all tickets closed by a specific account, and see how many are returned by that query.

The JQL would look like this:

project = <your project> AND status changed to CLOSED by <the user in question>

If you wanted to further narrow it down by a date range, you could add a "during" clause:

project = <your project> AND status changed to CLOSED during (2019-09-01, 2019-11-12) by <the user in question> ORDER BY updated DESC
TAGS
AUG Leaders

Atlassian Community Events