Can anyone have any idea related to the requirment,
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
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 ??"
Hi @[deleted]
That's what i said...
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.
Sorry @Nir Haimov its not applying the 6am to 3pm filter on each day
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))
It looks like you're new here. Sign in or register to get started.
