JQL Since Last Date

Question

Hi,

I am trying to make a JQL query that will show issues that I have worked on since the last of our status meetings. We have them every Monday and Thursday.

I am not sure how to epxress this in JQL though...the during() clause is where I'm stuck. Is there a way to do this? The functionality I want is below, but ideally, I don't want to hardcode the dates.

"(status CHANGED DURING("2013/1/28 11:00", "2013/1/31 10:00")) AND assignee=currentUser() ORDER BY created DESC, key DESC, summary DESC"

Any help would be appreciated. Thanks!

Jobin Kuruvilla [Adaptavist] · Answer

Pretty much. What I meant though is to create 2 gadgets and keep both of them in the dashboard without changing. One on the left and another on the right ;)

Jon L1 · Answer

I wanted to put this on our JIRA Dashboard -- that would mean I would have to change it twice a week, which is not much better than just setting the dates manually.

This basically requires a comparison operator, but it doesn't look like JQL allows for conditionals.

Jobin Kuruvilla [Adaptavist] · Answer

Create 2 filters. One after Monday before Thursday. Another after Thursday before end of week. Wouldn't that work?