JQL 関数

Custom fields of type Approval

=

!= , ~ , !~ , > , >= , < , <= , IS , IS NOT , IN , NOT IN , WAS , WAS IN , WAS NOT , WAS NOT IN , CHANGED

• 承認済みのすべてのリクエストを検索:
  approvals = approved()

Custom fields of type Approval

=

!= , ~ , !~ , > , >= , < , <= , IS , IS NOT , IN , NOT IN , WAS , WAS IN , WAS NOT , WAS NOT IN , CHANGED

• John Smith による承認が必要または必要だったリクエストを検索:
  approvals = approver(jsmith)

• Find requests that require or required approval by John Smith or Sarah Khan:
  approvals = approver(jsmith, skhan)

SLA

=,!=

~、!~、>、>=、<、<=、IS、IS NOT、IN、NOT IN、WAS、WAS IN、WAS NOT、WAS NOT IN、CHANGED

• Find issues where an SLA (“Time to First Response”) was breached:
  "Time to First Response" = breached()

Custom fields of type Cascading Select

IN , NOT IN

= , != , ~ , !~ , > , >= , < , <= IS , IS NOT, WAS , WAS IN , WAS NOT , WAS NOT IN , CHANGED

• "Location" カスタム フィールドの 1 階層の値が "USA"、2 階層の値が "New York" となっている課題を検索:
  location in cascadeOption("USA", "New York")

• Find issues where a custom field ("Location") has the value "USA" for the first tier and any value (or no value) for the second tier:
  location in cascadeOption("USA")

• Find issues where a custom field ("Location") has the value "USA" for the first tier and no value for the second tier:
  location in cascadeOption("USA", none)

• "Location" カスタム フィールドの 1 階層と 2 階層の両方に値を持たない課題を検索:
  location in cascadeOption(none)

• Find issues where a custom field ("Referrer") has the value "none" for the first tier and "none" for the second tier:
  referrer in cascadeOption("\"none\"", "\"none\"")

• Find issues where a custom field ("Referrer") has the value "none" for the first tier and no value for the second tier:
  referrer in cascadeOption("\"none\"", none)

Custom fields of types Multiple Choice and Dropdown

IN,NOT IN

= , != , ~ , !~ , > , >= , < , <= , IS , IS NOT, WAS , WAS IN ,
WAS NOT , WAS NOT IN , CHANGED

• Find issues where a custom field ("Product Version") has the value
  ”123”:
  "Product Version[Select List (multiple choices)]" in choiceOption(123)

Sprint

IN,NOT IN

= , != , ~ , !~ , > , >= , < , <= , IS , IS NOT, WAS , WAS IN ,
WAS NOT , WAS NOT IN , CHANGED

• 完了済みのスプリントに割り当てられているすべての課題を検索:
  sprint in closedSprints()

SLA

=,!=

~ , !~ , >, >= , < , <= , IS , IS NOT , IN , NOT IN , WAS ,
WAS IN , WAS NOT , WAS NOT IN , CHANGED

• Find issues where an SLA (“Time to First Response”) has completed at least one cycle:
  "Time to First Response" = completed()

Component

IN,NOT IN

=、!=、~、!~、>、>=、<、<=、IS、IS NOT、WAS、WAS IN、WAS NOT、WAS NOT IN、CHANGED

• 自身がリードであるコンポーネントのオープンな課題を検索:
  component in componentsLeadByUser() AND status = Open

• Bill がリードであるコンポーネントのオープンな課題を検索:
  component in componentsLeadByUser(bill) AND status = Open

Created, Due, Resolved, Updated, custom fields of type Date/Time

= , != , > , >= , < , <= , WAS* , WAS IN* , WAS NOT* , WAS NOT IN*, CHANGED*

* Only in predicate 

~ , !~ , IS , IS NOT , IN , NOT IN

• Find issues that have been created during your current session:
  created > currentLogin()

Assignee, Reporter, Voter, Watcher, Creator, custom fields of type User

=,!=

~ , !~ , > , >= , < , <= , IS , IS NOT , IN , NOT IN , WAS ,
WAS IN, WAS NOT , WAS NOT IN , CHANGED

• Find issues that are assigned to you:
  assignee = currentUser()

• Find issues that were reported by you but are not assigned to you:
  reporter = currentUser() AND assignee != currentUser()

Assignee, Reporter, Voter, Watcher, custom fields of type User

IN,NOT IN

= , != , ~ , !~ , > , >= , < , <= , IS , IS NOT , WAS , WAS IN ,
WAS NOT IN , WAS NOT , CHANGED

• Find all requests reported by customers in the APAC region:
  reporter in customerDetail("Region", "APAC")

• Find all requests reported by customers who are not technical contacts:
  reporter not in customerDetail("Role", "Technical Contact")

AffectedVersion, FixVersion, custom fields of type Version

=,!=

~ , !~ , > , >= , < , <= , IS , IS NOT , IN , NOT IN , WAS ,
WAS IN, WAS NOT , WAS NOT IN , CHANGED

• Find issues whose fix version is the earliest unreleased version of the “ABC” project:
  fixVersion = earliestUnreleasedVersion(ABC)

• Find issues that relate to the earliest unreleased version of the “ABC” project:
  affectedVersion = earliestUnreleasedVersion(ABC) or fixVersion = earliestUnreleasedVersion(ABC)

where inc is an optional increment of (+/-)nn(y|M|w|d|h|m). If the time unit qualifier is omitted, it defaults to the natural period of the function, e.g. endOfDay("+1") is the same as endOfDay("+1d"). If the plus/minus (+/-) sign is omitted, plus (+) is assumed.

Created, Due, Resolved, Updated, custom fields of type Date/Time

= , != , > , >= , < , <= , WAS , WAS IN , WAS NOT , WAS NOT IN , CHANGED

~ , !~ , IS , IS NOT , IN , NOT IN

• 期限が今日中である課題を検索:
  due < endOfDay()

• 期限が明日中である課題を検索:
  due < endOfDay("+1")

where inc is an optional increment of (+/-)nn(y|M|w|d|h|m). If the time unit qualifier is omitted, it defaults to the natural period of the function, e.g. endOfMonth("+1") is the same as endOfMonth("+1M"). If the plus/minus (+/-) sign is omitted, plus (+) is assumed.

Created, Due, Resolved, Updated, custom fields of type Date/Time

= , != , > , >= , < , <= , WAS , WAS IN , WAS NOT , WAS NOT IN , CHANGED

~ , !~ , IS , IS NOT , IN , NOT IN

• 期限が今月中である課題を検索:
  due < endOfMonth()

• 期限が来月中である課題を検索:
  due < endOfMonth("+1")

• 期限が来月の 15 日である課題を検索
  due < endOfMonth("+15d")

where inc is an optional increment of (+/-)nn(y|M|w|d|h|m). If the time unit qualifier is omitted, it defaults to the natural period of the function, e.g. endOfWeek("+1") is the same as endOfWeek("+1w"). If the plus/minus (+/-) sign is omitted, plus (+) is assumed.

Created, Due, Resolved, Updated, custom fields of type Date/Time

= , != , > , >= , < , <= , WAS , WAS IN , WAS NOT , WAS NOT IN , CHANGED

~ , !~ , IS , IS NOT , IN , NOT IN

• 期日が今週中である課題 (初期設定では最終日は土曜日) を検索:
  due < endOfWeek()

• 期日が今週中である課題を検索 (最終日は日曜日):
  due < endOfWeek("+1d")

• 期限が来週中である課題を検索:
  due < endOfWeek("+1")

where inc is an optional increment of (+/-)nn(y|M|w|d|h|m). If the time unit qualifier is omitted, it defaults to the natural period of the function, e.g. endOfYear("+1") is the same as endOfYear("+1y"). If the plus/minus (+/-) sign is omitted, plus (+) is assumed.

Created, Due, Resolved, Updated, custom fields of type Date/Time

= , != , > , >= , < , <= , WAS , WAS IN , WAS NOT , WAS NOT IN , CHANGED

~ , !~ , IS , IS NOT , IN , NOT IN

• 期限が今年中である課題を検索:
  due < endOfYear()

• 期限が来年の 3 月中である課題を検索:
  due < endOfYear("+3M")

エンタイトルメント

IN,NOT IN

= , != , ~ , !~ , > , >= , < , <= , IS , IS NOT, WAS , WAS IN ,
WAS NOT , WAS NOT IN , CHANGED

• Find all issues related to an entitlement where the “Support Level” is “Gold”:
  entitlement in entitlementDetail("Support Level", "Gold")

エンタイトルメント

IN,NOT IN

= , != , ~ , !~ , > , >= , < , <= , IS , IS NOT, WAS , WAS IN ,
WAS NOT , WAS NOT IN , CHANGED

• Find all issues related to entitlements for the product “Acme Widget”:
  entitlement in entitlementProduct("Acme Widget")

SLA

=,!=

~ , > , >= , < , <= , IS , IS NOT , WAS , WAS IN , WAS NOT ,
WAS NOT IN , CHANGED

• 初回応答時間の目標を達成できなかった課題を検索:
  "Time to First Response" = everBreached()

Sprint

IN,NOT IN

= , != , ~ , !~ , > , >= , < , <= , IS , IS NOT, WAS , WAS IN ,
WAS NOT , WAS NOT IN , CHANGED

• 未開始のスプリントに割り当てられているすべての課題を検索:
  sprint in futureSprints()

Issue

IN,NOT IN

= , != , ~ , !~ , > , >= , < , <= , IS , IS NOT, WAS , WAS IN ,
WAS NOT , WAS NOT IN , CHANGED

• Find issues which you have recently viewed, that are assigned to you:
  issue in issueHistory() AND assignee = currentUser()

Issue

IN,NOT IN

= , != , ~ , !~ , > , >= , < , <= , IS , IS NOT, WAS , WAS IN ,
WAS NOT , WAS NOT IN , CHANGED

• "abc" の globalId を持つリモート リンクにリンクしている課題を検索:
  issue in issuesWithRemoteLinksByGlobalId(abc)

• "abc" または "def" の globalId を持つリモート リンクにリンクしている課題を検索:
  issue in issuesWithRemoteLinksByGlobalId(abc, def)

Created, Due, Resolved, Updated, custom fields of type Date/Time

= , != , > , >= , < , <= , WAS* , WAS IN* , WAS NOT* , WAS NOT IN*, CHANGED*

* Only in predicate 

~ , !~ , IS , IS NOT , IN , NOT IN

• Find issues that have been created during your last session:
  created > lastLogin()

AffectedVersion, FixVersion, custom fields of type Version

=,!=

~ , !~ , > , >= , < , <= , IS , IS NOT , IN , NOT IN , WAS ,
WAS IN, WAS NOT , WAS NOT IN , CHANGED

• Find issues whose fix version is the latest released version of the “ABC” project:
  fixVersion = latestReleasedVersion(ABC)

• Find issues that relate to the latest released version of the “ABC” project:
  affectedVersion = latestReleasedVersion(ABC) or fixVersion = latestReleasedVersion(ABC)

Issue

= , != , IN , NOT IN

~ , !~ , > , >= , < , <= , IS , IS NOT , WAS , WAS IN, WAS NOT , WAS NOT IN , CHANGED

• Find subtasks that are linked to a particular epic:
  linkedIssue = epicKey-123

Issue

IN,NOT IN

= , != , ~ , !~ , > , >= , < , <= , IS , IS NOT, WAS , WAS IN ,
WAS NOT , WAS NOT IN , CHANGED

• 特定の課題にリンクしている課題を検索:
  issue in linkedIssues(ABC-123)

• 特定の課題から特定のリンク タイプでリンクしている課題を検索:
  issue in linkedIssues(ABC-123,"is duplicated by")

• 指定されたタイプのリンクで特定の課題にリンクしている課題を検索:

  issue in linkedIssues(ABC-123, "is duplicated by", "is blocked by")

Assignee, Reporter, Voter, Watcher, Creator, custom fields of type User

IN , NOT IN , WAS IN , WAS NOT IN

= , != , ~ , !~ , > , >= , < , <= , IS , IS NOT , WAS , WAS NOT , CHANGED

• Find issues where the assignee is a member of the group
  "jira-administrators":
  assignee in membersOf("jira-administrators")

• 複数のグループおよび特定のユーザーで検索:
  reporter in membersOf("jira-administators") or reporter in membersOf("jira-work-management-users") or reporter=jsmith

• 特定のグループで検索 (特定のメンバーを除く):
  assignee in membersOf(QA) and assignee not in ("John Smith","Jill Jones")

• 特定のグループのメンバーを除外:
  assignee not in membersOf(QA)

Custom fields of type Approval

=

!= , ~ , !~ , > , >= , < , <= , IS , IS NOT , IN , NOT IN , WAS ,
WAS IN, WAS NOT , WAS NOT IN , CHANGED

• Find all requests that require your approval:
  approval = myApproval()

Custom fields of type Approval

=

!= , ~ , !~ , > , >= , < , <= , IS , IS NOT , IN , NOT IN , WAS ,
WAS IN, WAS NOT , WAS NOT IN , CHANGED

• Find all requests that currently require your approval:
  approvals = myPendingApproval()

Custom fields of type Approval

=

!= , ~ , !~ , > , >= , < , <= , IS , IS NOT , IN , NOT IN , WAS ,
WAS IN, WAS NOT , WAS NOT IN , CHANGED

• Find all requests that currently or previously required your approval
  approvals = myPending()

Created, Due, Resolved, Updated, custom fields of type Date/Time

= , != , > , >= , < , <= , WAS* , WAS IN* , WAS NOT* , WAS NOT IN*, CHANGED*

* Only in predicate 

~ , !~ , IS , IS NOT , IN , NOT IN

• 期限切れの課題を検索:
  duedate < now() and status not in (closed, resolved)

Sprint

IN,NOT IN

=、!=、~、!~、>、>=、<、<=、IS、IS NOT、WAS、WAS IN、WAS NOT、WAS NOT IN、CHANGED

• 未完了のスプリントに割り当てられた課題を検索:
  sprint in openSprints()

組織

IN,NOT IN

=、!=、~、!~、>、>=、<、<=、IS、IS NOT、WAS、WAS IN、WAS NOT、WAS NOT IN、CHANGED

• Find all requests shared with organizations in the APAC region:
  organizations in organizationDetail("Region", "APAC")

• Find all requests shared with organizations that are not in a platinum support level
  organizations not in organizationDetail("Support level", "Platinum")

• Find all unresolved requests shared with organizations that joined on 2023-08-24 where the date is in YYYY-MM-DD format: resolution = Unresolved AND Organizations in organizationDetail("Joined on", "2023-08-24")

• Consider a multi-select dropdown that can contain up to two values (option1 and option2). To create a query for all the organizations where both values are present:

  resolution = Unresolved AND Organizations in organizationDetail("Options", "option1") AND Organizations in organizationDetail("Options", "option2")

Assignee, Reporter, Voter, Watcher, custom fields of type User

IN , NOT IN , WAS IN , WAS NOT IN

= , != , ~ , !~ , > , >= , < , <= , IS , IS NOT , WAS , WAS NOT , CHANGED

• Find all requests sent by members of the “Atlassian” organization:
  reporter in organizationMembers("Atlassian")

• Find all requests sent by people who are not in the “Atlassian” or “ACME” organizations:
  reporter not in organizationMembers("Atlassian","ACME")

Issue

= , != , IN , NOT IN

~ , !~ , > , >= , < , <= , IS , IS NOT , WAS , WAS IN, WAS NOT , WAS NOT IN , CHANGED

• エピック DEMO-123 の課題とサブタスクを検索:
  parentEpic = DEMO 123

• エピック DEMO-1 または SAMPLE-4 の課題およびサブタスクを検索:
  parentEpic in (DEMO-1, SAMPLE-4)

SLA

=,!=

~ , > , >= , < , <= , IS , IS NOT , WAS , WAS IN , WAS NOT ,
WAS NOT IN , CHANGED

• 初回応答時間が一時停止している課題を検索:
  "Time to First Response" = paused()

Custom fields of type Approval

=,!=

~ , > , >= , < , <= , IS , IS NOT , WAS , WAS IN , WAS NOT ,
WAS NOT IN , CHANGED

• Find all requests that are awaiting approval:
  approvals = pending()

Custom fields of type Approval

=,!=

~ , > , >= , < , <= , IS , IS NOT , WAS , WAS IN , WAS NOT ,
WAS NOT IN , CHANGED

• John Smith による承認が必要なリクエストを検索:
  approvals = pendingBy(jsmith)

• Find requests that require approval by John Smith or Sarah Khan:
  approvals = pendingBy(jsmith, skhan)

Project

IN,NOT IN

= , != , ~ , !~ , > , >= , < , <= , IS , IS NOT, WAS , WAS IN ,
WAS NOT , WAS NOT IN , CHANGED

• 自身がリードであるプロジェクトのオープンな課題を検索:
  project in projectsLeadByUser() AND status = Open

• Bill がリードであるプロジェクトのオープンな課題を検索:
  project in projectsLeadByUser(bill) AND status = Open

permission パラメータには、企業管理対象プロジェクトの権限で説明されている任意の権限を指定できます。

Project

IN,NOT IN

= , != , ~ , !~ , > , >= , < , <= , IS , IS NOT, WAS , WAS IN ,
WAS NOT , WAS NOT IN , CHANGED

• 自身が "Resolve Issues" 権限を持つプロジェクトのオープンな課題を検索:
  project in projectsWhereUserHasPermission("Resolve Issues") AND status = Open

Project

IN,NOT IN

= , != , ~ , !~ , > , >= , < , <= , IS , IS NOT, WAS , WAS IN ,
WAS NOT , WAS NOT IN , CHANGED

• 自身が "Developer" ロールを持つプロジェクトのオープンな課題を検索:
  project in projectsWhereUserHasRole("Developers") AND status = Open

AffectedVersion, FixVersion, custom fields of type Version

IN,NOT IN

= , != , ~ , !~ , > , >= , < , <= , IS , IS NOT, WAS , WAS IN ,
WAS NOT , WAS NOT IN , CHANGED

• FixVersion が ABC プロジェクトのリリース済みバージョンである課題を検索:
  fixVersion in releasedVersions(ABC)

• ABC プロジェクトのリリース済みバージョンに関連する課題を検索:
  (affectedVersion in releasedVersions(ABC)) or (fixVersion in releasedVersions(ABC))

SLA

= , != , > , >= , < , <=

~ , !~ , IS , IS NOT , WAS , WAS IN , WAS NOT , WAS NOT IN , CHANGED

• 解決までの所要時間が 2 時間以内に違反する課題を検索:
  "Time to Resolution" < remaining("2h")

SLA

=,!=

~ , > , >= , < , <= , IS , IS NOT , WAS , WAS IN , WAS NOT ,
WAS NOT IN , CHANGED

• 初回応答時間の計測が実行中の課題を検索:
  "Time to First Response" = running()

タイプ

IN,NOT IN

=、!=、~、!~、>、>=、<、<=、IS、IS NOT、WAS、WAS IN、WAS NOT、WAS NOT IN、CHANGED

• サブタスクではない課題 (サブタスク意外の通常の課題タイプを持つ課題) を検索:
  issuetype in standardIssueTypes()

where inc is an optional increment of (+/-)nn(y|M|w|d|h|m). If the time unit qualifier is omitted, it defaults to the natural period of the function, e.g. startOfDay("+1") is the same as startOfDay("+1d"). If the plus/minus (+/-) sign is omitted, plus (+) is assumed.

Created, Due, Resolved, Updated, custom fields of type Date/Time

= , != , > , >= , < , <= , WAS , WAS IN , WAS NOT , WAS NOT IN , CHANGED

~ , !~ , IS , IS NOT , IN , NOT IN

• 今日作成された課題を検索:
  created > startOfDay()

• 昨日以降に作成された課題を検索:
  created > startOfDay("-1")

• 過去 3 日間で作成された課題を検索:
  created > startOfDay("-3d")

where inc is an optional increment of (+/-)nn(y|M|w|d|h|m). If the time unit qualifier is omitted, it defaults to the natural period of the function, e.g. startOfMonth("+1") is the same as startOfMonth("+1M"). If the plus/minus (+/-) sign is omitted, plus (+) is assumed.

Created, Due, Resolved, Updated, custom fields of type Date/Time

= , != , > , >= , < , <= , WAS , WAS IN , WAS NOT , WAS NOT IN , CHANGED

~ , !~ , IS , IS NOT , IN , NOT IN

• 今月作成された課題を検索:
  created > startOfMonth()

• 先月の 1 日以降に作成された課題を検索:
  created > startOfMonth("-1")

• 今月の 15 日以降に作成された新しい課題を検索
  created > startOfMonth("+14d")

where inc is an optional increment of (+/-)nn(y|M|w|d|h|m). If the time unit qualifier is omitted, it defaults to the natural period of the function, e.g. startOfWeek("+1") is the same as startOfWeek("+1w"). If the plus/minus (+/-) sign is omitted, plus (+) is assumed.

Created, Due, Resolved, Updated, custom fields of type Date/Time

= , != , > , >= , < , <= , WAS , WAS IN , WAS NOT , WAS NOT IN , CHANGED

~ , !~ , IS , IS NOT , IN , NOT IN

• 今週作成された新しい課題を検索 (既定では週の初めは日曜日)
  created > startOfWeek()

• 今週作成された新しい課題を検索 (週の初めは月曜日):
  created > startOfWeek("+1d")

• 先週以降に作成された課題を検索:
  created > startOfWeek("-1")

where inc is an optional increment of (+/-)nn(y|M|w|d|h|m). If the time unit qualifier is omitted, it defaults to the natural period of the function, e.g. startOfYear("+1") is the same as startOfYear("+1y"). If the plus/minus (+/-) sign is omitted, plus (+) is assumed.

Created, Due, Resolved, Updated, custom fields of type Date/Time

= , != , > , >= , < , <= , WAS , WAS IN , WAS NOT , WAS NOT IN , CHANGED

~ , !~ , IS , IS NOT , IN , NOT IN

• 今年作成された課題を検索:
  created > startOfYear()

• 昨年以降に作成された課題を検索:
  created > startOfYear("-1")

タイプ

IN,NOT IN

= , != , ~ , !~ , > , >= , < , <= , IS ,
IS NOT , WAS , WAS IN , WAS NOT IN ,
WAS NOT , CHANGED

• サブタスクである課題 (課題タイプがサブタスク課題タイプである課題) を検索:
  issuetype in subtaskIssueTypes()

AffectedVersion, FixVersion, custom fields of type Version

IN,NOT IN

= , != , ~ , !~ , > , >= , < , <= , IS ,
IS NOT , WAS , WAS IN , WAS NOT IN ,
WAS NOT , CHANGED

• Find issues whose fix version is an unreleased version of the “ABC” project:
  fixVersion in unreleasedVersions(ABC)

• Find issues that relate to unreleased versions of the “ABC” project:
  affectedVersion in unreleasedVersions(ABC)

Issue

IN,NOT IN

=、!=、~、!~、>、>=、<、<=、IS、IS NOT、WAS、WAS IN、WAS NOT IN、WAS NOT、CHANGED

• John Smith が更新した課題を検索:
  issuekey in updatedBy(jsmith)

• John Smith が過去 8 日間以内に更新した課題を検索
  issuekey in updatedBy(jsmith, "-8d")

• 2018 年の 6 月から 9 月の間に更新された課題を検索
  issuekey in updatedBy(jsmith, "2018/06/01", "2018/08/31")

• 以下の例のように過去 1 時間以内に更新された課題を検索する場合、小さな値はサポートされないため、1 日に切り上げられます。
  issuekey in updatedBy(jsmith, "-1h")

Issue

IN,NOT IN

=、!=、~、!~、>、>=、<、<=、IS、IS NOT、WAS、WAS IN、WAS NOT IN、WAS NOT、CHANGED

• 自身が投票した課題を検索:
  issue in votedIssues()

Issue

IN,NOT IN

= , != , ~ , !~ , > , >= , < , <= , IS ,
IS NOT , WAS , WAS IN , WAS NOT ,
WAS NOT IN , CHANGED

• 自身がウォッチしている課題を検索:
  issue in watchedIssues()

SLA

= , !=

~ , !~ , > , >= , < , <= , IS , IS NOT , WAS ,
WAS IN , WAS NOT ,WAS NOT IN , CHANGED

• Find issues where an SLA (“Time to First Response”) is within calendar hours:
  "Time to First Response" = withinCalendarHours()