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.
Hey Community mates! Claire here from the Software Product Marketing team. We all know software development changes rapidly, and it's often tough to keep up. But from our research, we've found the h...
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