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; } } }

created date and assigned query

Damon Robinson

Hi,

I need some help creating a JIRA query, and I'm not sure if it can even be done.

I need to understand the volume of tickets created within the previous month that are, or have been at some point in time, assigned to one of two queues for which I am responsible.

Whilst I can easily write a query for tickets created in the month, it only picks up those that are currently in my queue, not tickets that HAVE been in my queue, but since moved to another.

I would like to be able to identify how many unique tickets we have received within the given month, in order to identify increasing or decreasing trends.

Is this possible? cheers in advance for any help you can offer.

Accepted answers

All comments

Damon Robinson

sorry, i should add that by queue, i mean assigned group...

Jack Brickey

Well I need to know a little bit more about your queues but let’s assume that issues in your queue equate to issues that have you as the assignee then you could consider adding the following to you date query

and assignee was currentuser

Damon Robinson

Thanks for reply Jack,

The issues are not assigned to me specifically, but could be assigned to one of a number of consultants that work within each queue / assignment group.

So for example, queue / assignment group 1, might have consultants A, B & C, whilst queue / assignment group 2 has consultants D, E & F. Any of these could pick the ticket from the queue and assign to themselves.

Also, if possible, i would like to be able to see what tickets hit our assignment group, even if they did not get assigned a consultant within the group, For example, a misdirected ticket we immediately pass back to another assignment group. Even though we have not logged time against this issue, it has still needed a touch from our team and should be in our tickets recieved count.

Jack Brickey

So maybe instead of saying current user you could use - assignee was in (A,B,C)

now the tricky part would be if you didn’t get it assigned to anyone. So thinking about this more, to be able to do this I think you’re going to have to use some custom field that could be used to signify the queue. There may be another way I just can’t say for sure. The point is you need to be able to definitively identify the queue and the fact that issue ever hit that Queue.

Damon Robinson

thanks, but i cant work out how to query assignee was in "assignee group"?

i can live without the unassigned tickets being picked up, but i do need any tickets created in a month that were assigned to the group at any point...

Welcome!

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

Quick Links

Find more posts tagged with

cloud

jira-service-management