Need help to find the most recently updated issue

[Mehman_Sadigov]

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

[Ignacio Pulgar · Accepted solution]

Add that at the end.

[Mehman_Sadigov]

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]

Try this:

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

[Ignacio Pulgar]

I would recommend adding:

ORDER BY updated DESC