nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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,

Accepted answers

All comments

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

you may use something like

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

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!

BHUSHAN PATIL_fap6cn

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
<strong>startOfMonth(-1)</strong> represents the start of the previous month and
<strong>endOfMonth(-1)</strong> 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_fap6cn

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

Thanks@Yamam for your kind support

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

cloud

jira-software-cloud