|
cascadeOption()Search for issues that match the selected values of a 'cascading select' custom field. The parentOption parameter matches against the first tier of options in the cascading select field. The childOption parameter matches against the second tier of options in the cascading select field, and is optional. The keyword 構文
または
Supported Fields
サポートされる演算子例
^top of functions | ^^top of topic
closedSprints()
Search for issues that are assigned to a completed Sprint. (Note that it is possible for an issue to belong to both a completed Sprint(s) and an incomplete Sprint(s).) See also openSprints(). 構文
Supported Fieldsサポートされる演算子例
^top of functions | ^^top of topic
componentsLeadByUser()Find issues in components that are lead by a specific user. You can optionally specify a user, or if the user is omitted the current user (i.e. you) will be used. Note that if you are not logged in to JIRA, a user must be specified. 構文
または
Supported Fieldsサポートされる演算子例
^top of functions | ^^top of topic currentLogin()Perform searches based on the time at which the current user's session began. See also lastLogin. 構文
Supported Fieldsサポートされる演算子例
^top of functions | ^^top of topic currentUser()Perform searches based on the currently logged-in user. Note that this function can only be used by logged-in users. So if you are creating a saved filter that you expect to be used by anonymous users, do not use this function. 構文
Supported Fieldsサポートされる演算子例
^top of functions | ^^top of topic earliestUnreleasedVersion()Perform searches based on the earliest unreleased version (i.e. next version that is due to be released) of a specified project. See also unreleasedVersions. Note that the "earliest" is determined by the ordering assigned to the versions, not by actual Version Due Dates. 構文
Supported Fieldsサポートされる演算子例
^top of functions | ^^top of topic endOfDay()Perform searches based on the end of the current day. See also endOfWeek, endOfMonth and endOfYear; and startOfDay, startOfWeek, startOfMonth and startOfYear. 構文
または
where
Supported Fieldsサポートされる演算子例
^top of functions | ^^top of topic endOfMonth()Perform searches based on the end of the current month. See also endOfDay, endOfWeek and endOfYear; and startOfDay, startOfWeek, startOfMonth and startOfYear. 構文
または
where
Supported Fieldsサポートされる演算子例
^top of functions | ^^top of topic endOfWeek()Perform searches based on the end of the current week. See also endOfDay, endOfMonth and endOfYear; and startOfDay, startOfWeek, startOfMonth and startOfYear. For the endOfWeek() function the result depends upon your locale. For example, in Europe the first day of the week is generally considered to be Monday, while in the USA it is considered to be Sunday. 構文
または
where
Supported Fieldsサポートされる演算子例
^top of functions | ^^top of topic endOfYear()Perform searches based on the end of the current year. See also startOfDay, startOfWeek and startOfMonth; and endOfDay, endOfWeek, endOfMonth and endOfYear.
または
where
Supported Fieldsサポートされる演算子例
^top of functions | ^^top of topic issueHistory()最近閲覧した課題、つまり [課題] ドロップダウン メニューの [最近表示した課題] セクションにある課題を検索します。 注意:
構文
Supported Fieldsサポートされる演算子例
^top of functions | ^^top of topic lastLogin()Perform searches based on the time at which the current user's previous session began. See also currentLogin. 構文
Supported Fieldsサポートされる演算子例
^top of functions | ^^top of topic latestReleasedVersion()Perform searches based on the latest released version (i.e. the most recent version that has been released) of a specified project. See also releasedVersions(). Note that the "latest" is determined by the ordering assigned to the versions, not by actual Version Due Dates. 構文
Supported Fieldsサポートされる演算子例
^top of functions | ^^top of topic linkedIssues()Perform searches based on issues which are linked to a specified issue. You can optionally restrict the search to links of a particular type. Note that LinkType is case-sensitive. 構文
または
Supported Fieldsサポートされる演算子例
^top of functions | ^^top of topic membersOf()特定のグループのメンバーに基づく検索を実施します。 構文
Supported Fieldsサポートされる演算子例
^top of functions | ^^top of topic now()現在の時刻に基づいた検索を行います。 構文
Supported Fieldsサポートされる演算子例
^top of functions | ^^top of topic
openSprints()
Search for issues that are assigned to a Sprint which has not yet been completed. (Note that it is possible for an issue to belong to both a completed Sprint(s) and an incomplete Sprint(s).) See also closedSprints(). 構文
Supported Fieldsサポートされる演算子例
^top of functions | ^^top of topic
projectsLeadByUser()Find issues in projects that are lead by a specific user. You can optionally specify a user, or if the user is omitted the current user will be used. Note that if you are not logged in to JIRA, a user must be specified. 構文
または
Supported Fieldsサポートされる演算子例
^top of functions | ^^top of topic projectsWhereUserHasPermission()Find issues in projects where you have a specific permission. Note: This function operates at the project level. This means that if a permission (e.g. "Edit Issues") is granted to the reporter of issues in a project, then you may see some issues returned where you are Also note that this function is only available if you are logged in to JIRA. 構文
For the Supported Fieldsサポートされる演算子例
^top of functions | ^^top of topic projectsWhereUserHasRole()Find issues in projects where you have a specific role. Note that this function is only available if you are logged in to JIRA. 構文
Supported Fieldsサポートされる演算子例
^top of functions | ^^top of topic releasedVersions()Perform searches based on the released versions (i.e. versions that your JIRA administrator has released) of a specified project. You can also search on the released versions of all projects, by omitting the project parameter. See also latestReleasedVersion(). 構文
または
Supported Fieldsサポートされる演算子例
^top of functions | ^^top of topic standardIssueTypes()Perform searches based on "standard" Issue Types, that is, search for issues which are not sub-tasks. See also subtaskIssueTypes(). 構文
Supported Fieldsサポートされる演算子例
^top of functions | ^^top of topic startOfDay()Perform searches based on the start of the current day. See also startOfWeek, startOfMonth and startOfYear; and endOfDay, endOfWeek, endOfMonth and endOfYear. 構文
または
where
Supported Fieldsサポートされる演算子例
^top of functions | ^^top of topic startOfMonth()Perform searches based on the start of the current month. See also startOfDay, startOfWeek and startOfYear; and endOfDay, endOfWeek, endOfMonth and endOfYear. 構文
または
where
Supported Fieldsサポートされる演算子例
^top of functions | ^^top of topic startOfWeek()Perform searches based on the start of the current week. See also startOfDay, startOfMonth and startOfYear; and endOfDay, endOfWeek, endOfMonth and endOfYear. For the startOfWeek() function the result depends upon your locale. For example, in Europe the first day of the week is generally considered to be Monday, while in the USA it is considered to be Sunday. 構文
または
where
Supported Fieldsサポートされる演算子例
^top of functions | ^^top of topic startOfYear()Perform searches based on the start of the current year. See also startOfDay, startOfWeek and startOfMonth; and endOfDay, endOfWeek, endOfMonth and endOfYear.
または
where
Supported Fieldsサポートされる演算子例
^top of functions | ^^top of topic subtaskIssueTypes()Perform searches based on issues which are sub-tasks. See also standardIssueTypes(). 構文
Supported Fieldsサポートされる演算子例
^top of functions | ^^top of topic unreleasedVersions()Perform searches based on the unreleased versions (i.e. versions that your JIRA administrator has not yet released) of a specified project. You can also search on the unreleased versions of all projects, by omitting the project parameter. See also earliestUnreleasedVersion(). 構文
または
Supported Fieldsサポートされる演算子例
^top of functions | ^^top of topic votedIssues()Perform searches based on issues for which you have voted. Also see the Voter field. Note that this function can only be used by logged-in users. 構文
Supported Fieldsサポートされる演算子例
^top of functions | ^^top of topic watchedIssues()Perform searches based on issues which you are watching. Also see the Watcher field. Note that this function can only be used by logged-in users. 構文
Supported Fieldsサポートされる演算子例
Supported Fieldsサポートされる演算子例
|
JQLには次の一連の予約文字があります。
" ")"+""."","";""?""|""*""/""%""^""$""#""@""[""]"これらの文字をクエリで利用したい場合、次のようにする必要があります。
') or double quote-marks ("));The text fields are:
例:
version = "[example]" |
version = "4.2" |
summary ~ "\\[example\\]" |
summary ~ "4.2" |
JQL has a list of reserved words. These words need to be surrounded by quote-marks if you wish to use them in queries:
"abort", "access", "add", "after", "alias", "all", "alter", "and", "any", "as", "asc",
"audit", "avg", "before", "begin", "between", "boolean", "break", "by", "byte", "catch", "cf",
"char", "character", "check", "checkpoint", "collate", "collation", "column", "commit", "connect", "continue",
"count", "create", "current", "date", "decimal", "declare", "decrement", "default", "defaults", "define", "delete",
"delimiter", "desc", "difference", "distinct", "divide", "do", "double", "drop", "else", "empty", "encoding",
"end", "equals", "escape", "exclusive", "exec", "execute", "exists", "explain", "false", "fetch", "file", "field",
"first", "float", "for", "from", "function", "go", "goto", "grant", "greater", "group", "having",
"identified", "if", "immediate", "in", "increment", "index", "initial", "inner", "inout", "input", "insert",
"int", "integer", "intersect", "intersection", "into", "is", "isempty", "isnull", "join", "last", "left",
"less", "like", "limit", "lock", "long", "max", "min", "minus", "mode", "modify",
"modulo", "more", "multiply", "next", "noaudit", "not", "notin", "nowait", "null", "number", "object",
"of", "on", "option", "or", "order", "outer", "output", "power", "previous", "prior", "privileges",
"public", "raise", "raw", "remainder", "rename", "resource", "return", "returns", "revoke", "right", "row",
"rowid", "rownum", "rows", "select", "session", "set", "share", "size", "sqrt", "start", "strict",
"string", "subtract", "sum", "synonym", "table", "then", "to", "trans", "transaction", "trigger", "true",
"uid", "union", "unique", "update", "user", "validate", "values", "view", "when", "whenever", "where",
"while", "with"
You can use either single quote-marks ( |
(Note for JIRA administrators: this list is hard coded in the JqlStringSupportImpl.java file.)