Starlie

A free tool for Jira

JQL query builder

Pick one of six common Jira searches, add your project key and paste the query into Jira's advanced search.

Build your query

It's the WEB in WEB-123. Leave it blank to search every project you can access.

Issues assigned to you that are not in the Done status category.

No login and no Jira connection. Your project key stays in this tab, and the page doesn't save it.

Search Jira from a native Mac app

Starlie is a Mac app for Jira. You write JQL with autocomplete and syntax highlighting, and each issue opens in its own window.

Try Starlie for MacSee how Starlie works

7-day free trial, then paid.

Six JQL examples for everyday work

These recipes use Jira Cloud syntax. Paste a query into Jira's advanced (JQL) search to run it. What you get back depends on your permissions and the fields your Jira site has.

My unfinished work

Issues assigned to you that are not in the Done status category.

assignee = currentUser() AND statusCategory != Done ORDER BY updated DESC

Work in active sprints

Unfinished issues in any sprint that has started and isn't complete. Needs the Sprint field from Jira Software. Results can span several sprints and boards.

sprint IN openSprints() AND statusCategory != Done ORDER BY updated DESC

Unassigned issues

Unfinished issues with no assignee, newest first. Add a project key to limit it to your team's backlog.

assignee IS EMPTY AND statusCategory != Done ORDER BY created DESC

Overdue issues

Unfinished issues due before today, earliest due first. Excludes issues due today and issues with no due date.

due < startOfDay() AND statusCategory != Done ORDER BY due ASC

Work untouched for 7 days

Unfinished issues last updated at least seven days ago. It checks the last update, not how long an issue has been in its current status.

updated <= "-7d" AND statusCategory != Done ORDER BY updated ASC

Issues created in the last 7 days

Issues created in the last seven days, newest first. Includes completed issues, so you see everything that came in.

created >= "-7d" ORDER BY created DESC

A few things to know

Custom statuses work. The Done status category includes the completed statuses in your workflow, even if your team calls them "Closed" or "Shipped."

Dates use the timezone set in Jira. "Overdue" means due before the start of today. "-7d" counts back seven days from the current time.

A project key is not a project name. The key must start with a letter, followed by letters, numbers or underscores. This tool can't check whether the project exists or whether you have access to it.

For more complex searches, see Atlassian's JQL field reference and JQL function reference.