Filter: Incidents created on a specific day of the week

[Chris]

Hey Guys,

I guess, its easy for you guys, but i dont get it.

I'd like to create a filter that shows me incidents created only on a specific weekday; let's say monday.

so i'd like to know which requests are created on mondays.

Got help for me? :)

Thanks and greets

Chris

[Mikael Sandberg]

Hi @Chris,

Welcome to Atlassian Community!

To get issues created on a specific day you can use the startOfWeek() function, which by default starts on Sundays. So in your case the JQL would look something like this:

issuetype = Incident AND created = startOfWeek("+1d") 

[Chris]

Thanks for your quick answer @Mikael Sandberg 

I did a test but it doesnt seem to work.

It sounds logical and the syntax is correct, but there are no incidents shown.

I testet it already with 2d and 3d and i did a test with "createdDate" instead of "created". but none of them work.

Any ideas?

[Mikael Sandberg]

Ah, my brain was thinking faster than I was typing. The correct syntax would be

created > startOfWeek("+1d") AND created < startOfWeek("+2d")

This would give you issues that were created on Monday

[Chris]

Thanks @Mikael Sandberg 

that works.

but: it only shows incdents created on monday this week. In this case only incidents created today.

What i want is to see incidents created on every monday. or especially i'd like to see incidents created on saturdays for the last 4 months.

is this possible?

Thanks again :)

[Chris]

@Mikael Sandberg I dont' wanna be anoying, but i got a little bit of time pressure and did not get to create this filter by myself.

Could you please help me again? :)

[Mikael Sandberg]

There is no function that would allow you to get all issues created on a specific day of the week for all time. You would have to string together multiple created > startOfWeek("xxx") AND created < startOfWeek("xxx") in that case, something like this:

(created > startOfWeek("+1d") AND created < startOfWeek("+2d") OR created > startOfWeek("-6d") AND created < startOfWeek("-5d") OR ... )

[IOC]

Thank you I finally found the working query

[salob]

can you share please @IOC ? Thanks

[Davide Giglioli]

Hello @IOC 

I've the same requirement.

could you please share your solution?

Thanks