Issue filtering

[Philippa Ford]

Hi 

I am building a report, and have the following filters:

updated >= -6w AND project in (VFECER, VFEW, VFEINT, VFEPIP, VFEVER, Design) AND status = Done AND SPRINT is not EMPTY AND TYPE not in (Incident)

I have 2 questions:

1) for one Jira issue key (Jira card) I seem to have multiple sprints showing, how can I have this report set so it only shows the latest sprint name that the card was completed in?

2) I set this report up so it shows me updates from 6 weeks, but is there a filter I can use that has fixed dates instead? Say I want to see all the Jira cards that have been completed in Q1?

[Derek Fields _RightStar_ · Accepted solution]

1) You would need something ScriptRunner, with the inSprint() function or the previousSprint() function to filter to a specific sprint. 

2) You can use fixed dates by specifying the fixed date instead of a relative date.

For example "updated >= 2022-01-01 AND update <= 2022-03-31" will return all tickets updated in Q1 of 2022.

[Philippa Ford]

thank you!