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

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

Krishnan_nifuj4

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.

Accepted answers

Trudy P Claspill

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?

All comments

Trudy P Claspill

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.

Krishnan_nifuj4

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 P 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_nifuj4

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

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

jira-software-cloud