Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
Community Members
Community Events
Community Groups

Ability to search (JQL) based on a specific weekday

Dirk Ronsmans Community Leader Apr 27, 2022


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?


1 answer

1 vote
Tessa Tuteleers Community Leader Apr 27, 2022

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

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

Like Tessa Tuteleers likes this
Dirk Ronsmans Community Leader Apr 27, 2022

Hi @Tessa Tuteleers ,

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 :)

Suggest an answer

Log in or Sign up to answer

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you