JQL filtering tickets for assignee group per current week

Marta Grzegorzewska_215w5j

Hello Fellow Jirers,

 

tried to find a hint on my question in the forum & docs, but to no avail.

I am trying to filter the below conditions - the filtering results should show the tickets that are:

• assigned to a specific assignee group (no listing user by user)
• updated by any member of this assignee group in the current week (Mon-Fri, even if I am filtering on Wednesday, it should dynamically list the rising list thoughout the week)
• filtered by a custom field "XYZ" = "PR", "XYZ" = QA etc.
• should include both resolved and unresolved issues
• no specific project should be defined, as the team receives requests from different projects by getting assigned as a group to the ticket

The goal of this filter is to check the progress on throughput of 3 different queues of issues - we are setting maximum limit on actionning upon specific queues weekly and try to find out a way to track and monitor those ticket limits throughut the week. 

I was trying to use the below query:

assignee in (membersOf(groupX)) AND updatedDate = startOfWeek(0) ORDER BY createdDate ASC

 

but it shows false results + it does not account that the update made in the ticket is done by the user of the assignee group.

 

I would appreciate some hints on where do I get this JQL wrong.

 

Thanks a lot in advance!

 

Marta

Mohamed Benziane

Hello Marta,

If you want to see a particular user or member of a group made an update, you will need to use the "changed by" operator, unfortunetaly it only work with the fields below :

Priority, Reporter, Resolution, Assignee, Fix Version and Status

 

So your query will looks like :

assignee in (membersOf(groupX)) AND status changed by memberof(your_group_name) and updated >= startOfWeek(0) and updated<= endofweek() ORDER BY createdDate ASC

 

hope this helps