The instructions on this page describe how to define and execute a search using the advanced search. You can also define and execute a search using the quick search or using basic searching.

高度な検索とは

An advanced search allows you to use structured queries to search for JIRA issues. Your search results will be displayed in the Issue Navigator, where you can export them to MS Excel and many other formats. You can also save and subscribe to your advanced searches if you wish.

高度な検索を実行するときには、JIRA クエリ言語 (JQL) を使用します。

A simple query in JQL (also known as a 'clause') consists of a field, followed by an operator, followed by one or more values or functions. For example, the following simple query will find all issues in the "TEST" project:

project = "TEST"

(This example uses the Project field, the EQUALS operator, and the value "TEST".)

Be aware that it is not possible to compare two fields.

JQL gives you some SQL-like syntax, such as the ORDER BY SQL keyword and ISNULL() SQL function (i.e. the NULL keyword in JQL). However, JQL is not a database query language. For example, JQL does not have a SELECT statement.

関連項目 :

高度な検索を実行するには

Choose Issues > Search for Issues. The issue navigator will be displayed.
- 既存の検索条件がある場合は、New filter (新しいフィルター)ボタンをクリックして検索条件をリセットします。
- Advanced (詳細設定)リンクが表示されたら、クリックして高度な検索に切り替えます。
Type your query using the fields, operators and field values or functions.
Search (検索) ボタンをクリックしてクエリを実行します。

Performing Text Searches

You can use Lucene's text-searching features when performing searches on the following fields, using the CONTAINS operator:

要約
説明
環境
コメント
custom fields which use the "Free Text Searcher"; this includes custom fields of the following built-in Custom Field Types
- フリーテキストフィールド (無制限のテキスト)
- テキストフィールド (255 文字までのテキスト)
- 読み取り専用テキストフィールド

The JQL field "text" as in text ~ "some words" searches an issue's Summary, Description, Environment, Comments. It also searches all text custom fields. If you have many text custom fields you can improve performance of your queries by searching on specific fields, e.g.
Summary ~ "some words" OR Description ~ "some words"

For details, please see the page on Performing Text Searches.

自動入力を使用する

クエリを入力すると、JIRA はコンテキストを認識し、次のように「オートコンプリート」候補のリストを表示します:

The list of auto-complete suggestions is displayed alphabetically and includes the first 15 matches. Note that auto-complete suggestions are not offered for function parameters.

注意:

If no auto-complete suggestions are offered, your administrator may have disabled the "JQL Auto-complete" feature for your JIRA instance.
If you prefer not to be offered auto-complete suggestions, click the "Turn off auto-complete" link below the "Query" box.

Auto-complete suggestions are not offered for all fields. Check the fields reference to see which fields support auto-complete.

「高度な」検索と「簡易」検索の切り替え

In general, a query created using 'Simple Search' will be able to be translated to 'Advanced Search' (i.e. JQL), and back again.

ただし、「高度な検索」を使用して作成されたクエリを「簡易検索」に変換することはできません。特に次のような場合は変換できません。

the query contains an OR operator (note you can have an IN operator and it will be translated, e.g. project in (A, B))
- i.e. even though this query: (project = JRA OR project = CONF) is equivalent to this query: (project in (JRA, CONF)), only the second query will be translated.
NOT 演算子を含むクエリ
EMPTY 演算子を含むクエリ
比較演算子 (!=、IS、IS NOT、>、>=、<、<=) を含むクエリ
the query specifies a field and value that is related to a project (e.g. version, component, custom fields) and the project is not explicitly included in the query (e.g. fixVersion = "4.0", without the AND project=JRA). This is especially tricky with custom fields since they can be configured on a Project/Issue Type basis. The general rule of thumb is that if the query cannot be created in the 'Simple Search' form, then if it is created using 'Advanced Search' it will not be able to be translated to 'Simple Search'.

演算子の優先順位の設定

You can use parentheses in complex JQL statements to enforce the precedence of operators.

例えば、SysAdmin プロジェクトの解決済みの課題すべてと、システム管理者 (bobsmith) に現状、割り当てられているすべての課題を検索したい場合、括弧を使用してクエリ内のブーリアン演算子の優先順位を変更できます。
例:

(status=resolved AND project=SysAdmin) OR assignee=bobsmith

括弧を使用しない場合、ステートメントは左から右に評価されます。

You can also use parentheses to group clauses, so that you can apply the NOT operator to the group.

キーワード参照

JQL のキーワードは、次のいずれかを行う単語または語句です。

2 つ以上の句を結合して複雑な JQL クエリを形成する
1 つ以上の句のロジックを変更する
alters the logic of operators
JQL クエリ内に明確な定義がある
JQL クエリの結果を変更する特定の関数を実行する

キーワードのリスト:

AND
または
NOT
EMPTY
NULL
ORDER BY

AND

複数の句を組み合わせて検索を絞り込むために使用します。

Note that you can use parentheses to control the order in which clauses are executed.

例

"New office" プロジェクト内のすべてのオープンな課題を検索:
```
project = "New office" and status = "open"
```
jsmith に割り当てられたオープンかつ緊急のすべての課題を検索:
```
status = open and priority = urgent and assignee = jsmith
```
jsmith に割り当てられていない、特定のプロジェクト内のすべての課題を検索:
```
project = JRA and assignee != jsmith
```
複数のプロジェクトにおいて、複数のバージョン番号で構成される特定のリリースに対するすべての課題を検索:
```
project in (JRA,CONF) and fixVersion = "3.14"
```
報告者と担当者が Jack、Jill、John のいずれでもないすべての課題を検索:
```
reporter not in (Jack,Jill,John) and assignee not in (Jack,Jill,John)
```

^top of keywords | ^^top of topic

または

複数の句を組み合わせて検索範囲を広げるために使用します。

Note that you can use parentheses to control the order in which clauses are executed.

(Note: also see IN, which can be a more convenient way to search for multiple values of a field.)

例

jsmith または jbrown のいずれかが作成したすべての課題を検索:
```
reporter = jsmith or reporter = jbrown
```
期限切れまたは期限が設定されていないすべての課題を検索:
```
duedate < now() or duedate is empty
```

^top of keywords | ^^top of topic

NOT

Used to negate individual clauses or a complex JQL query (a query made up of more than one clause) using parentheses, allowing you to refine your search.

(Note: also see NOT EQUALS ("!="), DOES NOT CONTAIN ("!~"), NOT IN and IS NOT.)

例

jsmith 以外のすべてのユーザーに割り当てられたすべての課題を検索:
```
not assignee = jsmith
```
jsmith または jbrown が作成していないすべての課題を検索:
```
not (reporter = jsmith or reporter = jbrown)
```

^top of keywords | ^^top of topic

EMPTY

Used to search for issues where a given field does not have a value. See also NULL.

Note that EMPTY can only be used with fields that support the IS and IS NOT operators. To see a field's supported operators, check the individual field reference.

EMPTY と NOT EQUALS (!=) は同じではありません。

例

Find all issues without a DueDate:
```
duedate = empty
```
または
```
duedate is empty
```

^top of keywords | ^^top of topic

NULL

Used to search for issues where a given field does not have a value. See also EMPTY.

Note that NULL can only be used with fields that support the IS and IS NOT operators. To see a field's supported operators, check the individual field reference.

例

Find all issues without a DueDate:
```
duedate = null
```
または
```
duedate is null
```

^top of keywords | ^^top of topic

ORDER BY

検索結果の並び順の基準として使用する値を持つフィールドを指定するために使用します。

既定では、フィールド独自の並び順が使用されます。昇順 (asc) または降順 (desc) を指定することで、この順序を上書きできます。

例

Find all issues without a DueDate, sorted by CreationDate:
```
duedate = empty order by created 
```
Find all issues without a DueDate, sorted by CreationDate, then by Priority (highest to lowest):
```
duedate = empty order by created, priority desc
```
Find all issues without a DueDate, sorted by CreationDate, then by Priority (lowest to highest):
```
duedate = empty order by created, priority asc
```

Ordering by Components or Versions will list the returned issues first by Project and only then by the field's natural order (see JRA-31113).

^top of keywords | ^^top of topic

演算子参照

An operator in JQL is one or more symbols or words which compares the value of a field on its left with one or more values (or functions) on its right, such that only true results are retrieved by the clause. Some operators may use the NOT keyword.

演算子の一覧:

EQUALS: =
NOT EQUALS: !=
GREATER THAN: >
GREATER THAN EQUALS: >=
LESS THAN: <
LESS THAN EQUALS: <=
IN
NOT IN
CONTAINS: ~
DOES NOT CONTAIN: !~
IS
IS NOT
WAS
WAS IN
WAS NOT IN
WAS NOT
CHANGED

EQUALS: =

The "=" operator is used to search for issues where the value of the specified field exactly matches the specified value. (Note: cannot be used with text fields; see the CONTAINS operator instead.)

To find issues where the value of a specified field exactly matches multiple values, use multiple "=" statements with the AND operator.

例

jsmith が作成したすべての課題を検索:
```
reporter = jsmith
```
John Smith が作成したすべての課題を検索:
```
reporter = "John Smith"
```

ページ

Viewport

Confluence

詳細検索

課題の検索

このページの内容

このセクションの項目

関連コンテンツ

お困りですか?

高度な検索とは

高度な検索を実行するには

Performing Text Searches

自動入力を使用する

「高度な」検索と「簡易」検索の切り替え

演算子の優先順位の設定

キーワード参照

AND

例

または

例

NOT

例

EMPTY

例

NULL

例

ORDER BY

例

演算子参照

EQUALS: =

例

NOT EQUALS: !=

例

GREATER THAN: >

例

GREATER THAN EQUALS: >=

例

LESS THAN: <

例

LESS THAN EQUALS: <=

例

IN

例

NOT IN

例

CONTAINS: ~

例

DOES NOT CONTAIN: !~

例

IS

例

IS NOT

例

WAS

例

WAS IN

例

WAS NOT IN

例

WAS NOT

例

CHANGED

例

フィールド参照

このセクションの項目

関連コンテンツ