Identify all issues created after their sprint started or with little time between Created and Due

[mateus_oliveira]

We need to identify all the issues created after their sprint started, or all the issues with a difference of Created Date and Due Date smaller than 3 days.

The thing is, I need this regarding multiple sprints (completed and ongoing), I need the issues list, not the quantity.

I thought of filling a field with the difference between 2 dates (be it the Sprint Start or the Created Date), and then gathering all issues whose number is less than 3, but since our Jira has about 4000 issues, just searching won't cut, since there's a limit of issues the automation can gather (100, if I'm not mistaken).

I can't find any way to find and group these issues... I know a bit of JQL and the Smart Values, but I haven't found a way to implement any of these to get the list I need... Any tips are welcome...

Thanks!

[Ana Vitória Selista]

Olá Mateus, tudo bem?

Unfortunately, Jira’s native JQL does not support comparing date fields (e.g., dueDate - created < 3) or referencing the sprint’s start date directly.

A more scalable and accurate approach would be using the Jira REST API with a Python script. Here’s the idea:

1. Use the API to fetch all sprints from your board:

GET /rest/agile/1.0/board/{boardId}/sprint

2. For each sprint, retrieve its startDate.
3. Get all issues in that sprint:

GET /rest/agile/1.0/sprint/{sprintId}/issue

4. In your script, filter:
   1. Issues where created > sprint.startDate
   2. Or issues where the difference between dueDate and created is less than 3 days.

This method bypasses JQL and automation limits, gives you full control over logic, and allows you to export the data as needed.

That said, this approach requires some technical knowledge, so it may not be the quickest solution if you’re not comfortable with those tools.