Here is the filter I am trying to use. Clearly I could break them up but I was hoping to combine them into one.
Does JQL not support more complicated queries?
project = SRFS AND resolution = Unresolved AND (("CB Complete?"=No AND "CB"> 0 AND "CB Due Date">= startOfWeek(-1) AND "CB Due Date"<= endOfWeek(-1)) OR ("PWD Complete?"=No AND "PWD" > 0 AND "PWD Due Date">=startOfWeek(-1) AND "PWD Due Date"<= endOfWeek(-1)) OR ("RTL Complete"=No AND "RTL"> 0 AND "RTL Due Date">= startOfWeek(-1) AND "RTL Due Date"<= endOfWeek(-1)))
Filter should work, I've had filters a lot more complicated than that.
Are you missing data at the end of weeks?
It's possible that endOfWeek() returns a timestamp at midnight and the "<=" will only include issues with the timestamp of exactly midnight (start of day) and not timestamps during the whole day.
Hi there! Shannon from Statuspage here. 👋 With Cyber Monday quickly approaching, we're looking to hear from Atlassian customers – specifically from teams who touch incident response li...
Connect with like-minded Atlassian users at free events near you!Find a group
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG
You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs