I need to keep track of all open defects with priority critical that are still open after 1 day, but I need to exclude Saturdays and Sundays.
Same for defects that are high priority but that are still open after 2 days also excluding weekends.
I need to still be able to track the items even if they are marked as done. So all items that missed the SLA are shown.
I tried using the following but didn't work:
Project = Rocket AND issuetype = bug AND Priority=high AND status = "Done" AND resolutiondate >= startOfWeek() AND resolutiondate <= endOfWeek() AND issueFunction in dateCompare("created", "resolutiondate", "workingDaysBetween(created, resolutiondate) <= 2")
Error:
Scripted function "dateCompare" compilation failure. Contact administrator and check logs. Message: The comparison must contain exactly one comparison operator which is either >, <, =, <= or >=.
If there is a better way, I'm all ears.
Thanks
Hi Roberto,
Please check the below JQL search
For open defects with priority "Critical" that are still open after 1 working day (excluding weekends)
project = Rocket AND issuetype = Bug AND priority = Critical AND status != Closed AND status != Resolved AND created <= -1d AND resolutiondate is EMPTY AND created >= startOfWeek(-1w) AND created <= endOfWeek(-1w) OR (created <= -1d AND resolutiondate is EMPTY AND created >= endOfWeek(-2w) AND created <= startOfWeek(-2w))
For high priority defects still open after 2 working days (excluding weekends)
project = Rocket AND issuetype = Bug AND priority = High AND status != Closed AND status != Resolved AND created <= -2d AND resolutiondate is EMPTY AND created >= startOfWeek(-1w) AND created <= endOfWeek(-1w) OR (created <= -2d AND resolutiondate is EMPTY AND created >= endOfWeek(-2w) AND created <= startOfWeek(-2w))
Thanks
Hi Ramyaallena,
The JQL search does not work. It doesn't show any errors, but it doesn't show high priority defects still open after 2 working days (excluding weekends).
Thanks
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.