JQL Blocks: Visual JQL Builder & Sprint Dates for Jira

JQL Blocks builds a Jira search from blocks — project, status, people, dates, sprints, your own fields — with AND, OR, groups and NOT, and writes the JQL as you go. It adds the sprint dates Jira never had as real fields, and finds the comment you remember.

A search from blocks, with the JQL beside it

Click a block to add it, or drag it into place. Each joint is AND or OR with one click; drop one block on another to make a group, the brackets Jira’s basic search cannot do; NOT turns a block or a group around. The JQL and the search in plain words follow every change. Copy JQL, Open in Jira search or Save as Jira filter — the filter is yours, like any other.

Already have JQL, a filter link or an answer from Ask Rovo? Paste it into Start from JQL or a filter link and get blocks back; parts no block covers stay as JQL text.

Results with sprint dates and days left

Show results lists the issues right under the blocks, 50 at a time, with the columns you choose — your own fields too — and Days left in the sprint. Danger zone marks the issues with more story points than days left. Export the rows to CSV.

Sprint dates as Jira fields

Six read-only fields on every issue that is or was in a sprint: Sprint start date, Sprint end date, Sprint complete date, Sprint count, Sprint state and Added after sprint start. Use them anywhere Jira takes a field: "Sprint end date" < now() AND statusCategory != Done in a filter, a column in the list view, a value in Automation. Two JQL functions go further: issue in sprintEndsBetween("2026-11-01", "2026-11-30") and issue in addedAfterSprintStart().

The fields are filled once after the install — about 1,200 issues a minute — and then follow sprint changes by themselves within a few minutes; a nightly check fixes anything missed.

Find comments, not just issues

Find → Comments searches inside comments: words, where you commented, where you are mentioned, an author and a period. Each comment shows with its issue and the words marked, and Open the comment jumps to it.

Also included

• During a sprint — created, resolved or changed status during a board’s current sprint, the previous one, or the last N.
• Ready-made searches — carried over and not done, sprint ends this week and not started, my open issues in the active sprint, and more.
• My searches — save, rename, open, and share a search with your team.
• Undo — Ctrl+Z steps back through the last changes.
• Keyboard all the way — the ⋯ menu of each block moves it in and out of groups without dragging, and every option explains itself with a ?.

Runs on Atlassian

JQL Blocks is built on Atlassian Forge and makes no calls outside Atlassian. Searches and comments are read as you, with your Jira permissions, and are not stored. The app keeps only your saved searches and settings inside your Atlassian site. See the privacy policy.

Related apps

• Agent Ready — check every Jira issue before an AI coding agent or a person picks it up.
• Deadline Tracker — overdue and upcoming work across projects on one board.
• Kanban Status Board — drag issues across real workflow statuses with WIP limits.