Search for issues since last issue exported

[MudCo]

Hi Team,

I am using the below query to extract all issues in the last 11 days. 

project ="ABC" AND "Dept" in (56793) AND resolved>= -11d AND resolution = Done ORDER BY resolved DESC

The output, for example looks like this. So the latest resolved is on top PRJ-123.

PRJ-123

PRJ-234

PRJ-345

What I have been trying to find is the list of issues since the last issue I exported i.e PRJ-123. Is there a way to change this query to give me issues created and/or resolved since PRJ-123?

[Walter Buggenhout · Accepted solution]

Hi @MudCo,

You can search for 

Key > PRJ-123 

Hope this helps!

[Walter Buggenhout]

On a side note - that will not work if your issues are from different projects (which your question seems to suggest). So in that case, how do you know if an issue was exported or not?

[MudCo]

Sorry I did missed to mention the issues are all from one single project and since I was doing a sample query, I made a mistake of putting 'ABC' in the project which should have been 'PRJ'. Didn't quite think that clearly white pinning that down and good to know it won't work with multiple projects in a single query. 

I think I accepted the answer thinking it worked but I have another problem here. I have replacing 'ABC' with 'PRJ' as that was a error:

by using project ="PRJ" AND "Dept" in (56793) AND key> PRJ-123 AND resolution = Done ORDER BY resolved DESC

I only get issues that are greater in value of PRJ-123, as in I get PRJ-124 and PRJ-125 (it does not consider the resolution date). What I was looking for is any issues 'resolved' after the issue PRJ-123 was resolved. In real case, if someone resolves PRJ-123 much earlier than PRJ-125, then my query will only show the existing issues resolved after PRJ-124, not in the order of resolution, but whatever 'exists' after PRJ-123.  

[Walter Buggenhout]

No worries, @MudCo; Jira does not let you compare dates from different issues in JQL. That is why I was asking you how you can determine which issues have been exported.

You might want to label them if that is important for you, so you can simply modify your query to only return issues that were not exported yet. Quite literally: when you export issues, also add a label to them and next time search for issues that do not have that label yet. 

[MudCo]

Ahhh I see. Ok now I understand why it didn't work. Labelling sounds like a good idea. I am going to try that. Thanks for your suggestion!