Hello,
From my filter I want to show only the Jiras that were closed a week ago.
Is this possible ?
(issuefunction in issuesInEpics("filter = 163764")) AND (status = Closed AND Resolved >= startOfWeek(-1))
Hello @Melissa C
Let us assume that the above filter was run today - 2024-07-22.
The way you have the filter written currently using
Resolved >= startOfWeek(-1)
...will get you all issues with a Resolved date that is equal to or greater than 2024-07-14. That would include issues with the Resolved date on the 14th, 15th, 16th, etc. up to and included today, the 22nd.
startOfWeek() is a reference to the Sunday of the current week (2024-07-21). Adding the parameter -1 indicates you want the Sunday of the previous week (2024-07-14).
Given that functionality of startOfWeek, can you clarify what you mean by the issues being closed "a week ago"?
Do you mean they were closed on exactly the date seven days before today? Or is there some date range you want to consider?
Perhaps if you provide some examples of Resolved dates for issue that you would and would not want included in the results, and the date the filter is being executed, then we can give you the correct guidance.
@Trudy P Claspill
Thank you for the explanation!
To give more context here's how we would use this query, We have progress meeting on Monday morning, where we go over issues closed the previous week and those issues that have a sprint assigned and those that have not been scheduled
This jql gets me all the issues with a spring and those without -issuefunction in issuesInEpics("filter = 163764"), But this also give me ALL the closed issues.
We only want to see those resolved in the previous week.
I'm at a loss there! help!
issuefunction in issuesInEpics("filter = 163764")
That part of your filter is getting you all issues that are children of Epics, from Epics that match the criteria of the filter with ID=163764.
What is the criteria of filter 163764?
Do you really want to constrain the results to only issues that are children of the specified Epics? If you do, and you want to constrain the result set more to only the issues Resolved in the past calendar week (Sunday through Saturday) then use this filter
If that does not get you what you want, please provide details about the filter you are using to select the Epics, and examples of issue that are included that you think should not be, and issues that are excluded that you think should be included.
@Trudy P Claspill Thank you!
filter = 163764 = project = XYZ AND fixVersion = "2024-Q3"
This filter is the base, It shows all of the Epics with a Fix Version of 2024-Q3 - These are all of the Epics that the Team will work on in Q3, in these Epics we have a number of Issues/Tasks that need to be completed. To get all of the Issues in filter 163764, I use "issuefunction in issuesInEpics("filter = 163764") " which are all of the Tasks that need to be completed before we can complete the Epic.
Those Issues/Task are assigned a sprint and that is what we would like to report on. Items Closed in the last week and anything that is scheduled(has a sprint).
This filter only gave me the Closed items (16) for the last week only, So these should show up with the open ones
I thought maybe combine filters but that didnt' work either
It looks like you're new here. Sign in or register to get started.
