JQL Query

[Anette Noll]

Hi,

I want to make the following selection:

all issues that changed to status completed during the last cw (14.-20 Sept. 2024) and that are actually in status completed (to avoid to show those that changed to completed at a point in time and than changed to another status again)

I use this jql:

project = P0ZEAE AND type IN ("Task KATB", "Sub-task KATB") AND status CHANGED TO "completed" During (startOfWeek(-1), endOfWeek(-1)) AND status = Completed

But the selection also shows issues with update date 21. Sept 2024.

Why is that? What is wrong with this jql?

Thank you very much for feedback!

[Rilwan Ahmed]

Hi @Anette Noll ,

Use JQL as below 

Project = "P0ZEAE"and issuetype in  ("Task KATB", "Sub-task KATB") and status changed to "completed" during (startOfWeek(-1w), endOfWeek(-1w))

[Anette Noll]

Hi Rilwan Ahmed,

thanks for your feedback.

It makes no difference in the filter results with or without "w"

[Fazila Ashraf]

Hi @Anette Noll 

If the problem is with the update date not reflecting in the given week range, i suppose the update could be other status changes or field edits on the ticket. Can you check that?

Also checking whether you wanted the range (14.-20 Sept. 2024) or (14.-20 Oct. 2024)

[Walter Buggenhout]

Hi @Anette Noll,

I don't see anything wrong with your JQL. Not having access to your site / data, it is a wild guess what might be wrong.

I would recommend having a close look at the issue(s) with and update date of Sept 24 and screen the history tab for status changes during last week. That may explain why they are returned by your filter, as the only fields you are searching for are project / issue type / status.

Hope this helps!