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

HarshaVardhan July 5, 2018

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
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
July 5, 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):.*") 

HarshaVardhan July 5, 2018

Is there anything instead of going for scriptrunner ??

Comment

Log in or Sign up to comment
TAGS
AUG Leaders

Atlassian Community Events