高度な検索 - 演算子参照

このページの内容

お困りですか?

アトラシアン コミュニティをご利用ください。

コミュニティに質問

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: =

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"

^top of operators | ^^top of topic

NOT EQUALS: !=

The "!=" operator is used to search for issues where the value of the specified field does not match the specified value. (Note: cannot be used with text fields; see the DOES NOT MATCH ("!~") operator instead.)

Note that typing field != value is the same as typing NOT field = value, and that field != EMPTY is the same as field IS_NOT EMPTY.

The "!=" operator will not match a field that has no value (i.e. a field that is empty). For example, component != fred will only match issues that have a component and the component is not "fred". To find issues that have a component other than "fred" or have no component, you would need to type: component != fred or component is empty.

  • jsmith 以外のすべてのユーザーに割り当てられたすべての課題を検索:

    not assignee = jsmith

    または

    assignee != jsmith
  • jsmith に割り当てられていないすべての課題を検索:

    assignee != jsmith or assignee is empty
  • 自分以外が報告した、自分に割り当てられていないすべての課題を検索:

    reporter = currentUser() and assignee != currentUser()
  • 報告社または担当者が John Smith 以外のすべてのユーザーであるすべての課題を検索:

    assignee != "John Smith" or reporter != "John Smith"
  • 未割り当てのすべての課題を検索:

    assignee is not empty

    または

    assignee != null

^top of operators | ^^top of topic

GREATER THAN: >

The ">" operator is used to search for issues where the value of the specified field is greater than the specified value. Cannot be used with text fields.

Note that the ">" operator can only be used with fields which support ordering (e.g. date fields and version fields). To see a field's supported operators, check the individual field reference.

  • 投票数が 4 票より多いすべての課題を検索:

    votes > 4
  • 期限切れのすべての課題を検索:

    duedate < now() and resolution is empty
  • 優先度が "Normal" より高いすべての課題を検索:

    priority > normal

^top of operators | ^^top of topic

GREATER THAN EQUALS: >=

The ">=" operator is used to search for issues where the value of the specified field is greater than or equal to the specified value. Cannot be used with text fields.

Note that the ">=" operator can only be used with fields which support ordering (e.g. date fields and version fields). To see a field's supported operators, check the individual field reference.

  • 投票数が 4 票以上のすべての課題を検索:

    votes >= 4
  • 期限が 2008 年 12 月 31 日以降のすべての課題を検索:

    duedate >= "2008/12/31"
  • 過去 5 日間に作成されたすべての課題を検索:

    created >= "-5d"

^top of operators | ^^top of topic

LESS THAN: <

The "<" operator is used to search for issues where the value of the specified field is less than the specified value. Cannot be used with text fields.

Note that the "<" operator can only be used with fields which support ordering (e.g. date fields and version fields). To see a field's supported operators, check the individual field reference.

  • 投票数が 4 票より少ないすべての課題を検索:

    votes < 4

^top of operators | ^^top of topic

LESS THAN EQUALS: <=

The "<=" operator is used to search for issues where the value of the specified field is less than or equal to than the specified value. Cannot be used with text fields.

Note that the "<=" operator can only be used with fields which support ordering (e.g. date fields and version fields). To see a field's supported operators, check the individual field reference.

  • 投票数が 4 票以下のすべての課題を検索:

    votes <= 4
  • 過去 1 ヶ月間 (30 日間) 更新されなかったすべての課題を検索:

    updated <= "-4w 2d"

^top of operators | ^^top of topic

IN

"IN" 演算子は、指定したフィールドの値が対象となる複数の値のいずれかである課題を検索するために使用します。値は、括弧で囲んだカンマ区切りのリスト形式で指定します。

Using "IN" is equivalent to using multiple EQUALS (=) statements, but is shorter and more convenient. That is, typing reporter IN (tom, jane, harry) is the same as typing reporter = "tom" OR reporter = "jane" OR reporter = "harry".

  • jsmith、jbrown、jjones のいずれかが作成したすべての課題を検索:

    reporter in (jsmith,jbrown,jjones)
  • 報告者または担当者が Jack または Jill であるすべての課題を検索:

    reporter in (Jack,Jill) or assignee in (Jack,Jill)
  • バージョン 3.14 またはバージョン 4.2 のすべての課題を検索:

    affectedVersion in ("3.14", "4.2")

^top of operators | ^^top of topic

NOT IN

"NOT IN" 演算子は、指定したフィールドの値が対象となる複数の値に含まれない課題を検索するために使用します。

Using "NOT IN" is equivalent to using multiple NOT_EQUALS (!=) statements, but is shorter and more convenient. That is, typing reporter NOT IN (tom, jane, harry) is the same as typing reporter != "tom" AND reporter != "jane" AND reporter != "harry".

The "NOT IN" operator will not match a field that has no value (i.e. a field that is empty). For example, assignee not in (jack,jill) will only match issues that have an assignee and the assignee is not "jack" or "jill". To find issues that are assigned to someone other than "jack" or "jill" or are unassigned, you would need to type: assignee not in (jack,jill) or assignee is empty.

  • Assignee (担当者) が Jack、Jill または John の課題をすべて検索する:

    assignee not in (Jack,Jill,John)
  • Assignee (担当者) が、Jack、Jill、John 以外の課題をすべて検索する:

    assignee not in (Jack,Jill,John) or assignee is empty
  • FixVersion (修正バージョン) が、'A'、'B'、'C'、'D' 以外の課題をすべて検索する:

    FixVersion not in (A, B, C, D)
  • FixVersion (修正バージョン) が、'A'、'B'、'C'、'D' 以外、または指定されていない課題をすべて検索する:

    FixVersion not in (A, B, C, D) or FixVersion is empty

^top of operators | ^^top of topic

CONTAINS: ~

"~" 演算子は、指定したフィールドの値が指定した値と一致する課題の検索に使用します (完全一致またはあいまい一致。以降の例を参照)。次のようなテキスト フィールドでのみ使用できます。

  • 要約
  • 説明
  • 環境
  • コメント
  • 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"

Note: when using the "~" operator, the value on the right-hand side of the operator can be specified using JIRA text-search syntax.

  • 要約に "win" の単語 (または "wins" などの指定した語を含む単語) を含むすべての課題を検索:

    summary ~ win
  • Find all issues where the Summary contains a wild-card match for the word "win":

    summary ~ "win*"
  • 要約に ”issue" および "collector" の単語を含むすべての課題を検索:

    summary ~ "issue collector"
  • Find all issues where the Summary contains the exact phrase "full screen" (see Reserved Characters for details on how to escape quote-marks and other special characters):

    summary ~ "\"full screen\""

^top of operators | ^^top of topic

DOES NOT CONTAIN: !~

"!~" 演算子は、指定したフィールドの値が指定した値のあいまい一致に該当しない課題の検索に使用します。次のようなテキスト フィールドでのみ使用できます。

  • 要約
  • 説明
  • 環境
  • コメント
  • 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"

Note: when using the "!~" operator, the value on the right-hand side of the operator can be specified using JIRA text-search syntax.

  • 要約に "run" の単語 (または "running" などの指定した語を含む単語) を含まないすべての課題を検索:

    summary !~ run

^top of operators | ^^top of topic

IS

The "IS" operator can only be used with EMPTY or NULL. That is, it is used to search for issues where the specified field has no value.

Note that not all fields are compatible with this operator; see the individual field reference for details.

  • 修正バージョンを持たないすべての課題を検索:

    fixVersion is empty

    または

    fixVersion is null

^top of operators | ^^top of topic

IS NOT

The "IS NOT" operator can only be used with EMPTY or NULL. That is, it is used to search for issues where the specified field has a value.

Note that not all fields are compatible with this operator; see the individual field reference for details.

  • 投票数が 1 票以上のすべての課題を検索:

    votes is not empty

    または

    votes is not null

^top of operators | ^^top of topic

WAS

The "WAS" operator is used to find issues that currently have, or previously had, the specified value for the specified field.

この演算子では次の述部を使用できます:
  • AFTER "date"
  • BEFORE "date"
  • BY "username"
  • DURING ("date1","date2")
  • ON "date"
この演算子は、フィールドの変更時にシステムで設定された値の名前 (例: "Resolved (解決済み)") を照合します。また、このオプションは値の名前と関連付けられた値 ID も照合します。つまり、"Resolved (解決済み)" と同様に "4" を照合します。

(Note: This operator can be used with the Assignee, Fix Version, PriorityReporter, Resolution and Status fields only.)

  • 現在または過去のステータスが "n Progress (進行中)" である (であった) 課題を検索する:

    status WAS "In Progress"
  • Joe Smith が 2 月 2 日より前に解決した課題を検索:

    status WAS "Resolved" BY jsmith BEFORE "2011/02/02"
  • Joe Smith が 2010 年に解決した課題を検索:

    status WAS "Resolved" BY jsmith DURING ("2010/01/01","2011/01/01")

^top of operators | ^^top of topic

WAS IN

The "WAS IN" operator is used to find issues that currently have, or previously had, any of multiple specified values for the specified field. The values are specified as a comma-delimited list, surrounded by parentheses.

Using "WAS IN" is equivalent to using multiple WAS statements, but is shorter and more convenient. That is, typing status WAS IN ('Resolved', 'Closed') is the same as typing status WAS "Resolved" OR status WAS "Closed".

この演算子では次の述部を使用できます:
  • AFTER "date"
  • BEFORE "date"
  • BY "username"
  • DURING ("date1","date2")
  • ON "date"
この演算子は、フィールドの変更時にシステムで設定された値の名前 (例: "Resolved (解決済み)") を照合します。また、このオプションは値の名前と関連付けられた値 ID も照合します。つまり、"Resolved (解決済み)" と同様に "4" を照合します。

(Note: This operator can be used with the Assignee, Fix Version, PriorityReporter, Resolution and Status fields only.)

  • 現在または過去のステータスが "Resolved" または "In Progress" であるすべての課題を検索:

    status WAS IN ("Resolved","In Progress")

^top of operators | ^^top of topic

WAS NOT IN

"WAS NOT IN" 演算子は、指定したフィールドの値が対象の複数の値のいずれかを持ったことがない課題を検索するために使用します。

Using "WAS NOT IN" is equivalent to using multiple WAS_NOT statements, but is shorter and more convenient. That is, typing status WAS NOT IN ("Resolved","In Progress") is the same as typing status WAS NOT "Resolved" AND status WAS NOT "In Progress".

この演算子では次の述部を使用できます:
  • AFTER "date"
  • BEFORE "date"
  • BY "username"
  • DURING ("date1","date2")
  • ON "date"
この演算子は、フィールドの変更時にシステムで設定された値の名前 (例: "Resolved (解決済み)") を照合します。また、このオプションは値の名前と関連付けられた値 ID も照合します。つまり、"Resolved (解決済み)" と同様に "4" を照合します。

(Note: This operator can be used with the Assignee, Fix Version, PriorityReporter, Resolution and Status fields only.)

  • "Resolved" または "In Progress" のステータスを持ったことがないすべての課題を検索:

    status WAS NOT IN ("Resolved","In Progress")
  • 2 月 2 日より前に "Resolved" または "In Progress" のステータスを持たなかったすべての課題を検索:

    status WAS NOT IN ("Resolved","In Progress") BEFORE "2011/02/02"

^top of operators | ^^top of topic

WAS NOT

"WAS NOT" 演算子は、指定したフィールドが対象の値を持ったことがない課題の検索に使用します。

この演算子では次の述部を使用できます:
  • AFTER "date"
  • BEFORE "date"
  • BY "username"
  • DURING ("date1","date2")
  • ON "date"
この演算子は、フィールドの変更時にシステムで設定された値の名前 (例: "Resolved (解決済み)") を照合します。また、このオプションは値の名前と関連付けられた値 ID も照合します。つまり、"Resolved (解決済み)" と同様に "4" を照合します。

(Note: This operator can be used with the Assignee, Fix Version, PriorityReporter, Resolution and Status fields only.)

  • ステータスが "In Progress (進行中)" ではなく、これまでにもなったことがない課題を検索する:

    status WAS NOT "In Progress"
  • 2 月 2 日より前に "In Progress" ステータスを持たなかった課題を検索:

    status WAS NOT "In Progress" BEFORE "2011/02/02"

^top of operators | ^^top of topic

CHANGED

The "CHANGED" operator is used to find issues that have a value which had changed for the specified field.

この演算子では次の述部を使用できます:

  • AFTER "日付"
  • BEFORE "日付"
  • BY "ユーザー名"
  • DURING ("日付1","日付2")
  • ON "日付"
  • FROM "古い値"
  • TO "新しい値"
  • 担当者が変更された課題を検索:

    assignee CHANGED
  • ステータスが "In Progress" から "Open " に変更された課題を検索:

    status CHANGED FROM "In Progress" TO "Open"
  • 現在の週の間にユーザー "freddo" が Priority を変更した課題を検索:

    priority CHANGED BY freddo BEFORE endOfWeek() AFTER startOfWeek()

^top of operators | ^^top of topic

最終更新日: 2014 年 1 月 7 日

この内容はお役に立ちましたか?

はい
いいえ
この記事についてのフィードバックを送信する
Powered by Confluence and Scroll Viewport.