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 · Accepted solution]

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.

[ana_dias]

I'm going to keep this discution open for a while.

If someone has another workaround I would be happy to know :)