How do I create a filter that displays issues created X# of business days in the past

Question

I am trying to create an automation rule that is scheduled to run every day an add a comment to issues that ware created 10 business days ago. This does not seem to be possible using a JQL filter (I can get it to work with calendars days using StartofDay).  I see that you can use smart values in a conditional filter, so I am trying {{issue.created.jqldate}} less than {{now.toBusinessDayBackwards(4)}}.  This results in no action perform even though I know I have issues that meet the criteria.  So is my conditional filter correct or what I trying to do even achievable?

Dave Stillwell · Answer

@Trudy P Claspill and @Kian Stack Mumo Systems

Seems I was able to get this solved by using 2 advanced compare filters

{{now.diff(issue.created).businessdays}} > -11

{{now.diff(issue.created).businessdays}} < -9

Thank you both for your help.

Dave Stillwell · Answer

That is what my filter is set to right now but unfortunately, that only works with calendar days.  It doesn't work for business days.

I wonder if what I am trying to do is possible with 2 advanced compare conditions?  I guess I can try it and see if it can get that to work building on @Kian Stack Mumo Systems suggestion.

Trudy P Claspill · Answer

You could use two conditions

{{issue.created}} > startOfDay(-10) and {{issue.created}} < startOfDay(-9)