assignee was in(xx,yy,dd) during last 14 days.

[Krishnan]

Hi All,

I would like to extract the bug ticket  that we have supported for the last 14 days.

I tired to use assignee was in (xx,yy,dd) DURING (startOfDay(-14d), startOfDay().

However its does not show the desired output. Could you please throw some light  how to use during with the functions to check anyone was assigned the ticket for the last 14 days.

[Trudy Claspill · Accepted solution]

Hello @Krishnan 

Welcome to the Atlassian community!

The query you specified:

assignee was in (xx,yy,dd) during(startOfDay(-14d), startOfDay())

...will list each issue where the assignee was "xx", "yy", or "dd"  at any point in the past two weeks up to the start of today.

If you are not getting the results that you expect, tell us how the results differ. Are there issue you think should be included that are not? Are there issues that are included that you think should not be?

[Krishnan]

Thanks for the response , I am getting way more than the expected result. Result shows any ticket which was updated during the last 14 days by anyone  thought   my list of assignee was never been as asignee during that period.

[Trudy Claspill]

The filter is not designed to return issues where the assignee was set to the specified users during the time period.

It is retrieving issues where the assignee was one of the specified users during the specified time period, regardless of when the assignee field was set.

If you want only the issues where the assignee was set to one of the specified users within the time period then you need to use this:

assignee CHANGED TO (xx,yy,dd) during(startOfDay(-14d), startOfDay())

[Krishnan]

okay. I was looking for the same what you had mentioned in the first set  - "It is retrieving issues where the assignee was one of the specified users during the specified time period, " however for me it was throwing the result with more ticket where the ticket updated with some one else as well. Can we have option to tighten that assignee was from the list for 14 days  and  some changes or comments happened only from list of assignees so that we can get the tickets which are worked or supported by assignee list 

[Trudy Claspill]

Hello @Krishnan 

The only native JQL related to issue searching that can look at the Comments is to search the content of the Comment. To do any searching based on who authored comments or when comments were created requires a third party app.

[Krishnan]

okay. I tried to use the following option and its  extract almost near result what I was looking for. 

(issuekey in updatedBy(xx, -14d) OR issuekey in updatedBy(yy, -14d) OR issuekey in updatedBy(zz, -14d) 

[Trudy Claspill]

Combining that with the JQL you have for selecting the issues assigned to the specified users would give you the assigned issues that were also updated by the assignees. It would not constrain the results to issues updated by only the assignees, and it could be that assignee xx updated an issue assigned to yy.

Did you have an additional question at this time related to this topic?

[Krishnan]

Yeah.  We wanted to check as a combination of the assignee of the team (xx,yy,xx), so interchange of assignee and updated between xx and yy should be fine. no , no more open question on this topic. 

[Trudy Claspill]

Wonderful!

If you have more questions, don't hesitate to start a new Question post.

If your questions in this post have all been addressed please consider marking the Answer thread as Accepted to help other users find posts with working solutions.

[Krishnan]

sure