ボードフィルター用の JQL クエリの例

You can use a JQL filter to make a board that shows the relevant work items 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.

When constructing your JQL query, it’s important to tell Jira where it should search for work items by including or excluding specific projects or boards.

When a query has to search through fewer work items, results load faster.

JQL フィルターによって、自分に割り当てられたすべての作業を表示するとします。ただし、あなたが取り組んでいるプロジェクトは組織全体で 2 つだけです。

このクエリは次のように機能します。

assignee is currentUser()

しかし、次のほうが良いでしょう。

project in (The Big Cheese, Project Kanban) and assignee is currentUser()

これには、次のような理由があります。

The first query searches through all of the work items in your site to find the ones assigned to you. The second query is more focused on your projects.

If your site has 10,000 work items Jira can look at the 500 work items in those projects and can ignore the remaining 9,500. Fewer work items to sort through, the quicker the query can run, even though the results are the same.

始めるのに役立つその他のクエリ

Show work items in different lifecycles

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

Select all work items you are interested in

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

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

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

Create a seperate board for completed work items

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

ラベルを使用して特定の作業ストリーム別に整理する

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

バグ修正チームにのみバグを表示する

project in (LIFE) AND team = bugfix AND workType = bug AND (fixVersion in unreleasedVersions() OR fixVersion is empty)

Show all work items that are unscheduled or in an unreleased fix version

project in (LIFE) AND (fixVersion in unreleasedVersions() OR fixVersion is empty

Show all work items in the next fix version to be released

project in (LIFE) AND fixVersion = earliestUnreleasedVersion(PROJECT KEY)