jql query

[pradeep auradkar]

Hi, I want to pull the No.of tickets worked by all the engineers in a month. what is  the jQL query ?

Please share the same, 

[BHUSHAN PATIL]

Hi @pradeep auradkar 

JQL doesn't directly provide a way to count the number of tickets worked. Instead, you can filter issues based on certain criteria.

Assuming you want to find issues that have been resolved by engineers within a specific month, you might use a query like this:

project = "your_project_name" AND assignee is not EMPTY AND resolved >= startOfMonth(-1) AND resolved <= endOfMonth(-1)

This query will fetch all issues that were resolved in the previous month
startOfMonth(-1) represents the start of the previous month and
endOfMonth(-1) represents the end of the previous month. 
Replace your_project_name with your actual project name

Also, if you feel my input help you please accept the answer.

Regards,
Bhushan

[pradeep auradkar]

Hi Bhushan,

Thank you very much for your inputs.  I attempted the same query which was shared by you.  After providing the Project name, it was pulled nearly 7500 tickets.!!! This included with all the other teammates who  are worked for this project.

All 7500 tickets are not required for me.  I have team with 10 members I just want to pull those tickets only which are worked by my team (10 members).  So what query I need to run to get the tickets related 10 members only

Thanks

Pradeep 

[Nic Brough -Adaptavist-]

Change the "assignee is not empty" to "assignee in (<list of your team members>)"

[BHUSHAN PATIL]

Hi @pradeep auradkar ,

Try this,

project = "your_project_name" AND assignee in (engineer1, engineer2, engineer3....engineer10) AND resolved >= startOfMonth(-1) AND resolved <= endOfMonth(-1)

 Replace "Your Project Name" with the name of your project and update the assignee in (engineer1, engineer2, engineer3....engineer10) part with the specific engineers' usernames or display names you want to include in the query.

[pradeep auradkar]

Hey Bhushan, great !! it worked...Thank you very much for your support 

[BHUSHAN PATIL]

Thats Great! please accept the answer. 

[Yamam Al Ghourani_ServiceRocket_]

Hi Pradeep! 

You may try something like:

project = "<PROJECT NAME>" AND (status was in ("<STATUS 1>", "<STATUS 2>") during ("2023/02/01", "2023/02/28") AND issuetype = "<ISSUETYPE>" ORDER BY key ASC, created ASC

OR 

you may use something like 

project= "<project>" AND (created>= -1m OR updated >= -1m) order by updated DESC

OR 

utilize createdBy and updatedBy in your JQL.

There are many ways to do so, you just need to understand how the JQL works, perhaps you can take a look at:

https://www.atlassian.com/blog/jira-software/jql-the-most-flexible-way-to-search-jira-14

Hope this helps!

[pradeep auradkar]

Thanks@Yamam for your kind support