Starlie

A free tool for Jira

Less syntax. More finding.

Build a JQL query for the work you need to see. Pick a search, add your project key, and paste it into Jira.

JQL query builder

The WEB in WEB-123. Leave blank for all projects you can access.

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

No login or Jira connection. Your project key stays in this tab and isn’t saved.

Keep Jira close on your Mac.

Starlie brings Jira search to a native Mac window, with JQL autocomplete and syntax highlighting. Find an issue, open it, and get back to work.

Try Starlie for MacSee how Starlie works

7-day free trial. Paid app after the trial.

Six JQL examples for everyday work

These recipes use Jira Cloud syntax. Paste a query into Jira’s advanced (JQL) search to run it. Results depend on your permissions and available fields.

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 started, incomplete sprint. Requires Jira Software’s sprint field; this can include multiple 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 focus on 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. This measures the last update, not time spent in a status.

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

Issues created in the last 7 days

Recently created issues, newest first. Includes completed work so you can see everything that came in.

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

A few things to know

Custom statuses are fine. The Done status category includes completed statuses in your workflow, even if your team calls them “Closed” or “Shipped.”

Dates follow Jira’s configured timezone. “Before today” uses the start of the day; “-7d” is a relative seven-day window.

A project key is not a project name. This tool accepts a letter followed by letters, numbers, or underscores. It cannot check whether a project exists or whether you can access it.

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