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
4,364,940
Community Members
 
Community Events
168
Community Groups

Find jira's created between 6am to 3pm for all days of current month.

I want to filter the issues created between 6am to 3pm, for which i have tried :

1)AND created > startOfDay("+6h")  AND created < startOfDay("+15h")

But this only shows the current day issues created between 6am to 3pm.

2)AND created > startOfMonth("+6h") AND created < endOfMonth("+15h")

3)AND created >= "2018/06/01 6:00" AND created <= "2018/06/30 15:00" 

But it shows the issue of the whole month,the 6am to 3pm filter can't be applied

 

Can anyone help me to "find the issues created between 6am to 3pm for all days of current month ??"

1 comment

Payne Rising Star Jul 05, 2018

If you have ScriptRunner installed, you could use a regex approach such as:

issueFunction in issueFieldMatch("project=BR and created > '2018-06-01' and created < '2018-07-01'",created,".* (06|07|08|09|10|11|12|13|14):.*") 

Is there anything instead of going for scriptrunner ??

Comment

Log in or Sign up to comment