• Products
  • Documentation
  • Resources

Example JQL queries for board filters

You can use a JQL filter to make a board that shows the relevant issues based on whatever criteria you want. JQL is a flexible yet robust logic that can be used in a variety of different ways. Learn more about the power of JQL queries.

However, you don’t need to start from scratch. Here’s some common simple queries to get you started:

Select all issues you are interested in

project = JSW AND (assignee = currentUser() or reporter = currentUser()) AND (fixVersion in unreleasedVersions() OR fixVersion is empty)

Show all issues for a team (using a label custom field named “team”)

project = JSW AND (team = ateam or team = dreamteam OR team = engineroom) AND (fixVersion in unreleasedVersions() OR fixVersion is empty)

Show issues in different lifecycles

project in (LIFE) and status in ("In Progress", "To do") ORDER BY Rank ASC

Create a seperate board for completed issues

project in (LIFE) and status in (Done, Duplicate) and statusCategory = Done ORDER BY assignee

Use labels to organize by specific work streams

project in (LIFE) and labels in (ui-only, android-app) ORDER BY Rank ASC

Only show your bugs in a bug fix team

project = JSW AND team = bugfix AND issuetype = bug AND (fixVersion in unreleasedVersions() OR fixVersion is empty)

Show all issues that are unscheduled or in an unreleased fix version

project = JSW AND (fixVersion in unreleasedVersions() OR fixVersion is empty

Show all issues in the next fix version to be released

project = JSW AND fixVersion = earliestUnreleasedVersion(PROJECT KEY)

Additional Help