Ability to search (JQL) based on a specific weekday

Question

Hi,

I've been looking thru the documentation but can't seem to find an answer to this.

We've been trying to figure out a JQL query where we can specify if an issue has been created on a specific weekday. The problem here is that we don't want it just for this week (which I could do with startOfWeek()) but for this weekday since we started creating issues.

e.g. All issues created on a Sunday (preferably even between specific times)

Anybody got a clue on how we could figure out that query?

Dirk Ronsmans · Answer

Hi @Piet Pieters ,

Thanks for confirming what I was fearing. I'm a bit hesitant to update all the old issues on this particular instance (100K issues) and want to avoid retriggering them/causing some communication to users.

For future issues I might implement the automation just to start keep track of it from now on.

@Mohamed Benziane

I did notice that was an option and we do have Scriptrunner (still on Server/DC) so I'll look a bit more in to that.

But as I suspected sadly no out of the box JQL option that I never heard of :)

Mohamed Benziane · Answer

You could also use scriptrunner to create a specific JQL function.

Tessa Tuteleers · Answer

Hi @Dirk Ronsmans ,

I'm not sure if you can do this without actually manually detailing every day with a DayOfMonth() separately.

I'm not aware of any apps that can help either, unless you use BI on top of your instance.

But you can get the day of the week as a smart value in automation, so maybe you can use that to set metadata to your issues and filter that way? (Label or something?)

The smart value would be {{issue.created.dayOfWeekName}}

Not really a direct answer but perhaps a usable workaround.

- Tessa