Find jira's created between 6am to 3pm of current month

[Deleted user]

Can anyone have any idea related to the requirment,

[Ignacio Pulgar]

This is doable natively, but it requires a really large JQL query.

For the query to be dynamic, with no need to update the dates, you may use something like this:

(created >= startOfMonth(6h) AND created <= startOfMonth(15h)) OR 
(created >= startOfMonth(30h) AND created <= startOfMonth(39h)) OR 
(created >= startOfMonth(54h) AND created <= startOfMonth(63h)) OR 
(created >= startOfMonth(78h) AND created <= startOfMonth(87h)) OR 
(created >= startOfMonth(102h) AND created <= startOfMonth(111h)) OR 
(created >= startOfMonth(126h) AND created <= startOfMonth(135h)) OR 
(created >= startOfMonth(150h) AND created <= startOfMonth(159h)) OR 
(created >= startOfMonth(174h) AND created <= startOfMonth(183h)) OR 
(created >= startOfMonth(198h) AND created <= startOfMonth(207h)) OR 
(created >= startOfMonth(222h) AND created <= startOfMonth(231h)) OR 
(created >= startOfMonth(246h) AND created <= startOfMonth(255h)) OR 
(created >= startOfMonth(270h) AND created <= startOfMonth(279h)) OR 
(created >= startOfMonth(294h) AND created <= startOfMonth(303h)) OR 
(created >= startOfMonth(318h) AND created <= startOfMonth(327h)) OR 
(created >= startOfMonth(342h) AND created <= startOfMonth(351h)) OR 
(created >= startOfMonth(366h) AND created <= startOfMonth(375h)) OR 
(created >= startOfMonth(390h) AND created <= startOfMonth(399h)) OR 
(created >= startOfMonth(414h) AND created <= startOfMonth(423h)) OR 
(created >= startOfMonth(438h) AND created <= startOfMonth(447h)) OR 
(created >= startOfMonth(462h) AND created <= startOfMonth(471h)) OR 
(created >= startOfMonth(486h) AND created <= startOfMonth(495h)) OR 
(created >= startOfMonth(510h) AND created <= startOfMonth(519h)) OR 
(created >= startOfMonth(534h) AND created <= startOfMonth(543h)) OR 
(created >= startOfMonth(558h) AND created <= startOfMonth(567h)) OR 
(created >= startOfMonth(582h) AND created <= startOfMonth(591h)) OR 
(created >= startOfMonth(602h) AND created <= startOfMonth(611h)) OR 
(created >= startOfMonth(626h) AND created <= startOfMonth(635h)) OR 
(created >= startOfMonth(650h) AND created <= startOfMonth(659h)) OR 
(created >= startOfMonth(674h) AND created <= startOfMonth(683h)) OR 
(created >= startOfMonth(698h) AND created <= startOfMonth(707h)) OR 
(created >= startOfMonth(722h) AND created <= startOfMonth(729h))

[Nir Haimov]

You can do something like:

project = XX AND  created >= "2018/01/01 6:00" AND created <= "2018/01/31 15:00"

I don't think you can use time (hours) with something dynamic that will recognize your current month, you will have to manually edit it once a month and change the dates

[Deleted user]

Hey Nir,

Its not working man. the query you gave i already tried it with :

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

but it shows the issue of the whole month,

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

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

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

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

[Nir Haimov]

Hi @[deleted]

That's what i said...

• startOfMonth()
• endOfMonth()
• startOfDay()
• startOfDay()

They are all dynamic members.

You can't use dynamic member with limit of hours.

If you want to include hours it have to be as i sent to you:

created >= "2018/01/01 6:00" AND created <= "2018/01/31 15:00"

You will get all the tasks created on January every day between 6am to 3pm.

Then, when you reach to February you will have to change your filter manually to:

created >= "2018/02/01 6:00" AND created <= "2018/02/28 15:00"

You will get all the tasks created on February every day between 6am to 3pm.

And so on for each month, so once a month you will have to go and edit your filter.

[Deleted user]

Sorry @Nir Haimov its not applying the 6am to 3pm filter on each day

[Deleted user]

Hey Nir,

Its not working man. the query you gave i already tried it with :

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

but the 6am to 3pm filter is not able to apply 

I want to filter the issues created between 6am to 3pm, But this shows all the issues created in the month

Can you help me to "find the issues created between 6am to 3pm of current month ??"

[Deleted user]

Below are some results of the above query

Created 06 30 2018 02 00 AM

Created 06 29 2018 04 14 PM

[Nir Haimov]

That's weird, my query works for me, that's why i gave it to you to use...

Maybe you need to check your date time format on the Jira server, maybe it's different then mine and that is why it's not work for you.

[Deleted user]

Hi @Nir Haimov

I think it is showing the issues created between "2018/06/01 6:00" AND  "2018/06/30 15:00"

the daily based time filter is not applied !!!

[Nir Haimov]

Hi @[deleted]

No need to shout at me.

I'm trying to help, and i understand your issue.

But event according to Atlassian documentation, this should work

https://confluence.atlassian.com/jirasoftwarecloud/advanced-searching-fields-reference-764478339.html?_ga=2.82218453.2120531044.1530683259-1935695412.1524042181#Advancedsearching-fieldsreference-ResolvedResolutionDateresolutionDateResolved

Of course you can use external plugin like scriptrunner to check the date time you want. 

I have no other solution for you, sorry.

[Deleted user]

Hey @Nir Haimov

My intention was not that...just discussing the issue  with you,

thanks a lot for your precious time. 

[an cheil]

Hi @Nir Haimov , 

Your solution will result to show data of all ticket in highlighted period as below screenshot: 

But Harsha is looking for something which only show all tickets which are created during below period. 

Do you have any idea to achieve this goal? 

Thanks,