It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Date time search for time

I have a project where we collect a date/time field for events.  I am wanting to pull a subset of the project based on the day of the week between certain times of the day without having to change the query string each time.

The following will show me everything that happens between Tuesday 12:00 AM PST and Thursday 11:59 PM PST.


project = "XYZ" AND "Start Time (PST)" >= startOfWeek(2d) AND "Start Time (PST)" <= startOfWeek(5d) AND status != Canceled ORDER BY "Start Time (PST)"

I want to get granular and show only things that happen between Tuesday 11:00 AM PST and Thursday 10:59 AM PST

2 answers

1 accepted

0 votes
Answer accepted
Payne Community Leader Aug 15, 2019

You can use hours rather than days, like this:

"Start Time (PST)" >= startOfWeek(59h) and "Start Time (PST)" < startOfWeek(107h)

That will only work for the current week.

You can use Power scripts for Jira to make this more generic

https://marketplace.atlassian.com/apps/43318/power-scripts-jira-script-automation?hosting=server&tab=overview

key in silJQLExpression("(dayOfWeek(created) == \"Tue\") or (dayOfWeek(created) == \"Wed\") or  (dayOfWeek(created) == \"Thu\")", "project = SD ")

Read the documentation on silJQLExpression. There are some caveats needed to make it work will. In particular, you want to "pre-filter" your query as much as possible first to reduce runtime and load. in the example above the "Project = SD" But you can use any valid JQL in the 2nd parameter to filter down your results as much as possible before applying sil conditions in the first parameter.

Suggest an answer

Log in or Sign up to answer
Community showcase
Posted in Jira

Demo Den Ep. 7: New Jira Cloud Reports

Learn how to use two new reports for next-gen projects in Jira Cloud:  Cumulative flow diagram and Sprint burndown chart. Ivan Teong, Product Manager, Jira Software, demos the Cumulative ...

260 views 1 2
Join discussion

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you