JQL query to return the last modified issues

[Defny]

Hello All,

Need your help.

I want to create a JQL query which will return the last modified issue.

For ex: user1 creates Issue1 and Issue 2
user2 modify the Issue1, 
if the user1 connect and run the jql, only the Issue1 shall be reported.

The jql shall be based on the currentuser connected

Thank you in advance.

[Thomas Deiler]

Dear @Defny,

unfortunately, there is no function called "last()".

But you can do following:

1. create a query for your project or projects that is ordered by creation date (descending) - and save
2. got to the dashboard and add the Result Filter Gadget
3. select your new filter
4. enter '1' in the 'Number of Results' field - save

Now, whenever you reload the gadget, the last created issue is displayed.

So long

Thomas

[Defny]

Hi Thomas,

Thank you very much for your input. 

I want the last modified issue not the last created issue. Could you help with the last modified issue.

[Thomas Deiler]

Easy, instead of sorting for createDate, sort for updateDate.

[Defny]

This will return all the issues created. But i need only the issues created by me.

[Thomas Deiler]

Dear @Defny,

then you have to add

AND reporter = currentUser()

to your JQL.

So long

Thomas