CODEWITHSUNDEEP
filterjirajql
vinothkumar r
vinothkumar r

Reputation: 25

JIRA JQL Search by Date - How to search Updated Issues on 1 Hour

These are my Requirements:

I need to get Updated JIRA issues through RSS Every 1 Hour or Minutes.

So how can I filter the issues for my requirements?

What I tried so far:

I have filtered like, updated > startOfDay(-0d) and updated < now()

First time it returns the all issues i created or modified to me. But after that it returns all the previous issues along with modified issues.

I need only

issues which modified between now() and before 1 hour.

How can I create a JQL query like this?

Upvotes: 1

Views: 7336

Answers (2)

Scott Dudley
Scott Dudley

Reputation: 3298

You want the following:

updated >= "-1h"

Upvotes: 5

Bananan
Bananan

Reputation: 609

Just write a query with where clause updated BETWEEN LocalDateTime.now().minusHours(1) AND LocalDateTime.now()?

Also you need to pass starting date (in my example LocalDateTime.now() from JodaTime is used) in order to get real start time instead of current time. It may be few seconds later and you will not find several issues updated on the beginning of last hour.

Upvotes: 0

Related Questions