The Atlassian Community can help you and your team get more value out of Atlassian products and practices.
Hi, how can I get JQL if I want to know that how many specific tickets are closed by a specific account?
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