How to dynamically filter a time range?

[Koloman Pfeffer]

Hi community, 

I'm trying to filter work items after a specific date and time field. So specifically I want the filter to show me all issues where the time of this field is between 0 AM and 8 AM, regardless of the date.

So far I only managed to create a filter with startOfDay, but this of course only shows me issues on the same day, I would like to see all issues that have a value between 0 and 8 AM in this date/time-field.

Is there any JQL function I'm overlooking or do you have any ideas how to solve this?

Thanks,
Koloman

[Michael Wohlgemuth · Accepted solution]

Greetings, 

you can use increments of hours in those functions. So something like that might help you: 

project = MOBL and created >= startOfDay() and created <= startOfDay("+12h")

This finds all issues in the project "MOBL" which have been created between the start of today, and 12 hours later. 

[Koloman Pfeffer]

Hi @Michael Wohlgemuth

Thanks for your answer. I got that far already, problem I have is, that I'd need to find all issues where the time is between 0 and 8 AM, no matter the day.

I guess it'll be a case of "hardcoding" the time increments for a week and letting the rule run once a day, so it'll at least put out the work items from the following week.

[Michael Wohlgemuth]

Hi @Koloman Pfeffer

understood. Yeah, in that case it isn't of much use. I guess that might only be possible by plugin or hardcoding indeed. 

I tried creating an automation that stores the time an issue was updated, but since number fields dont accept ":", im not sure how i would approach that tbh, because text fields bring with them another problem when searching them.

All in all, I'd probably try to argue with someone that the timespan in between the last and the current login should be reported on daily. That should probably catch all issues in that timeframe anyway. 

But yeah, sorry to have no better idea. Have a great day regardless :) 

[Koloman Pfeffer]

Hi @Michael Wohlgemuth 

Thanks for your insights, I feared, it might be that way. I think, we'll try something along the lines of what you wrote.

You too have a great day!