Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

Need help to find the most recently updated issue

Mehman_Sadigov August 2, 2018

Need help,

After sprint plan I had someone updating a ticket and wanted to know what ticket it was I am using this query but not helping me out. basically I want to know the updates in the backlog within the past 6 hours. 

updated >= -7H AND project = "XXXX" AND issuetype = "User Story" AND "Story Points" = 1

3 answers

1 accepted

1 vote
Answer accepted
Ignacio Pulgar
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
August 2, 2018

Add that at the end.

0 votes
Mehman_Sadigov August 2, 2018

ORDER BY updated DESC > = -7H  AND project = "XXXX" AND issuetype = "User Story" AND "Story Points" = 1

 

Tried it but query wouldn't process since it shows red. Any other suggestion?

Ignacio Pulgar
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
August 2, 2018

Try this:

updated >= -7H AND project = "XXXX" AND issuetype = "User Story" AND "Story Points" = 1 ORDER BY updated DESC

0 votes
Ignacio Pulgar
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
August 2, 2018

I would recommend adding:

ORDER BY updated DESC

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events