Way for JQL to find Issues in a particular Status for the previous day excluding weekends?

[Matt Steadman]

Hi,

Right now I have a JQL filter that is written like this:

project = "Project Name" and status was in ("Status 1", "Status 2") during (startofday(-1d), endofday(-1d))

Every morning I am using the number from this filter to enter into a spreadsheet to log data for historical information we use.

Tues-Fri this filter works fine. The problem is on Monday I have to go into the filter and manually update the numbers to -3d to ignore Sunday and Saturday. Or, copy the filter and updated those numbers so now there are now 2 filters instead of one, just slightly different. This becomes particularly cumbersome if you have multiple filters looking for these same date ranges for various different things.

I am just wondering if anyone knows of a way to accomplish this same Filter but have it skip the Sunday and Saturday days so that if I were to look at it on Monday it would show me last Fridays results and if I were to look at tomorrow on Tuesday it would show me yesterdays (Monday) results all just using a single filter?

Thanks,

[Dmitrii Apanasevich · Accepted solution]

I found a way to work with CF value. I created class which performs work, put it in parameters map.

So I can call class methods with $value parameter.