See done activies on the day before

ana_dias

Hi, there! I'm new using Jira Software and I need some help!

 

I want to filter all activities that have finished on the day before, so I can show that data on Stand Up Metting every day.

 

For that, I created a script bellow:

project = US AND issuetype != Epic AND (resolutiondate > -1d OR resolutiondate = endOfWeek()) ORDER BY Rank ASC

 

This script works fine on Tuesdays, Wednesdays, Thursdays and Fridays. The problem is when the current day is Monday, because it shows the activies that have finished on Sunday, but I need to see the Friday activities.

 

A Condition Structure like if should be great for me, but I'm not sure that command exists on JQL.

 

Is there a solution/workarround that works for both of cases? 

Benjamin_tmh9yg

HI @ana_dias 

 

There's no if structure. 

The workaround I use was separating the query into 2 and create a subscription. So, it automatically e-mails to me. 

subscribe to your current query for Tuesday-Friday.

create another query with -3 and subscribe for just monday. 

 

Then you get those updates daily in your e-mail to share with your team.