|
A keyword in JQL is a word or phrase that:
List of keywords:
AND複数の句を組み合わせて検索を絞り込むために使用します。 Note that you can use parentheses to control the order in which clauses are executed. 例
^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.) 例
^top of keywords | ^^top of topic NOTUsed 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.) 例
^top of keywords | ^^top of topic EMPTYUsed 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. 例
^top of keywords | ^^top of topic NULLUsed 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. 例
^top of keywords | ^^top of topic ORDER BY検索結果の並び順の基準として使用する値を持つフィールドを指定するために使用します。 既定では、フィールド独自の並び順が使用されます。昇順 ( 例
|
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 " To find issues where the value of a specified field exactly matches multiple values, use multiple " 例
^top of operators | ^^top of topic NOT EQUALS: !=The " Note that typing The " 例
^top of operators | ^^top of topic GREATER THAN: >The " Note that the " 例
^top of operators | ^^top of topic GREATER THAN EQUALS: >=The " Note that the " 例
^top of operators | ^^top of topic LESS THAN: <The " Note that the " 例
^top of operators | ^^top of topic LESS THAN EQUALS: <=The " Note that the " 例
^top of operators | ^^top of topic IN" Using " 例
^top of operators | ^^top of topic NOT IN" Using " The " 例
^top of operators | ^^top of topic CONTAINS: ~" Note: when using the " 例
^top of operators | ^^top of topic DOES NOT CONTAIN: !~" Note: when using the " 例
^top of operators | ^^top of topic ISThe " Note that not all fields are compatible with this operator; see the individual field reference for details. 例
^top of operators | ^^top of topic IS NOTThe " Note that not all fields are compatible with this operator; see the individual field reference for details. 例
^top of operators | ^^top of topic WASThe " 例
^top of operators | ^^top of topic WAS INThe " Using " 例
^top of operators | ^^top of topic WAS NOT IN" Using " 例
^top of operators | ^^top of topic WAS NOT" 例
^top of operators | ^^top of topic CHANGED
The " この演算子では次の述部を使用できます:
(Note: This operator can currently be used with the Status, Assignee, Priority, Reporter, Resolution and Fix Version fields only.) 例
|
A field in JQL is a word that represents a JIRA field (or a custom field that has already been defined in JIRA). In a clause, a field is followed by an operator, which in turn is followed by one or more values (or functions). The operator compares the value of the field with one or more values or functions on the right, such that only true results are retrieved by the clause.
フィールド一覧:
対象バージョンSearch for issues that are assigned to a particular Affects Version(s). You can search by version name or version ID (i.e. the number that JIRA automatically allocates to a version).
Note: this field supports auto-complete. 構文
フィールド タイプVERSION サポートされる演算子Note that the comparison operators (e.g. ">") use the version order that has been set up by your project administrator, not a numeric or alphabetic order. サポートされる関数例
^top of fields | ^^top of topic 担当者特定のユーザーに割り当てられた課題を検索します。検索条件にはユーザーのフルネーム、ID またはメールアドレスを使用できます。 Note: this field supports auto-complete. 構文
フィールド タイプUSER サポートされる演算子サポートされる関数例
^top of fields | ^^top of topic カテゴリ特定のカテゴリー内のプロジェクトに所属する課題を検索します。 Note: this field supports auto-complete. 構文
フィールド タイプCATEGORY サポートされる演算子サポートされる関数n/a 例
^top of fields | ^^top of topic コメントComment (コメント) に特定のテキストが含まれる課題を検索します。 JIRA text-search syntax can be used. Note: this field does not support auto-complete. 構文
フィールド タイプTEXT サポートされる演算子サポートされる関数n/a 例
^top of fields | ^^top of topic コンポーネントSearch for issues that belong to a particular component(s) of a project. You can search by component name or component ID (i.e. the number that JIRA automatically allocates to a component).
Note: this field supports auto-complete. 構文
フィールド タイプCOMPONENT サポートされる演算子サポートされる関数When used with the IN and NOT IN operators, 例
^top of fields | ^^top of topic 作成日Search for issues that were created on, before or after a particular date (or date range). Note that if a time-component is not specified, midnight will be assumed. Please note that the search results will be relative to your configured time zone (which is by default the JIRA server's time zone). Note: this field does not support auto-complete. 構文
Alias (エイリアス):
フィールド タイプDATE サポートされる演算子サポートされる関数例
^top of fields | ^^top of topic カスタム フィールドOnly applicable if your JIRA administrator has created one or more Custom Fields. 特定のカスタム フィールドに特定の値が入力された課題を検索します。 検索条件にはカスタム フィールド名またはカスタム フィールド ID (例: JIRA がカスタム フィールドに自動的に割り当てた番号) を使用できます。
注意:
構文
Alias (エイリアス):
フィールド タイプDepends on the Custom Field's configuration サポートされる演算子Different types of Custom Fields support different operators. For the default Custom Field Types, the following operators are supported:
サポートされる関数Different types of Custom Fields support different functions. For the default Custom Field Types, the following functions are supported:
例
^top of fields | ^^top of topic 説明Search for issues where the Description contains particular text. JIRA text-search syntax can be used. Note: this field does not support auto-complete. 構文
フィールド タイプTEXT サポートされる演算子サポートされる関数n/a 例
^top of fields | ^^top of topic 期限特定の日付 (または日付範囲)、それよりも前、またはそれよりも後に期限切れとなった課題を検索します。期日は日付とのみ関連付けられます (時刻ではない)。 Note: this field does not support auto-complete. 構文
Alias (エイリアス):
フィールド タイプDATE サポートされる演算子サポートされる関数例
^top of fields | ^^top of topic 環境Search for issues where the Environment contains particular text. JIRA text-search syntax can be used. Note: this field does not support auto-complete. 構文
フィールド タイプTEXT サポートされる演算子サポートされる関数n/a 例
^top of fields | ^^top of topic フィルターYou can use a saved filter to narrow your search. You can search by filter name or filter ID (i.e. the number that JIRA automatically allocates to a saved filter).
注意:
フィールド タイプフィルター サポートされる演算子サポートされる関数n/a 例
^top of fields | ^^top of topic 修正対象バージョンSearch for issues that are assigned to a particular Fix Version. You can search by version name or version ID (i.e. the number that JIRA automatically allocates to a version).
Note: this field supports auto-complete. 構文
フィールド タイプVERSION サポートされる演算子Note that the comparison operators (e.g. ">") use the version order that has been set up by your project administrator, not a numeric or alphabetic order. サポートされる関数例
^top of fields | ^^top of topic 課題キーSearch for issues with a particular Issue Key or Issue ID (i.e. the number that JIRA automatically allocates to an Issue). Note: this field does not support auto-complete. 構文
エイリアス:
フィールド タイプISSUE サポートされる演算子サポートされる関数When used with the IN or NOT IN operators, 例
^top of fields | ^^top of topic レベルOnly available if Issue Level Security has been enabled by your JIRA administrator. Search for issues with a particular Security Level. You can search by Issue Security Level name or Issue Security Level ID (i.e. the number that JIRA automatically allocates to an Issue Security Level).
Note: this field supports auto-complete. 構文
フィールド タイプSECURITY LEVEL サポートされる演算子サポートされる関数n/a 例
^top of fields | ^^top of topic 初期見積りOnly available if time-tracking has been enabled by your JIRA administrator. Search for issues where the Original Estimate is set to a particular value (i.e. a number, not a date or date range). "w"、"d"、"h"、"m" を使用して、週、日付、時間、分を指定します。 Note: this field does not support auto-complete. 構文
Alias (エイリアス):
フィールド タイプDURATION サポートされる演算子サポートされる関数n/a 例
^top of fields | ^^top of topic 親Only available if sub-tasks have been enabled by your JIRA administrator. Search for all sub-tasks of a particular issue. You can search by Issue Key or by Issue ID (i.e. the number that JIRA automatically allocates to an Issue). Note: this field does not support auto-complete. 構文
フィールド タイプISSUE サポートされる演算子サポートされる関数n/a 例
^top of fields | ^^top of topic PrioritySearch for issues with a particular Priority. You can search by Priority name or Priority ID (i.e. the number that JIRA automatically allocates to a Priority).
Note: this field supports auto-complete. 構文
フィールド タイプPRIORITY サポートされる演算子サポートされる関数n/a 例
^top of fields | ^^top of topic プロジェクトSearch for issues that belong to a particular Project. You can search by Project Name, by Project Key or by Project ID (i.e. the number that JIRA automatically allocates to a project). Note: this field supports auto-complete. 構文
フィールド タイプPROJECT サポートされる演算子サポートされる関数When used with the IN and NOT IN operators, 例
^top of fields | ^^top of topic 残余見積りOnly available if time-tracking has been enabled by your JIRA administrator. Search for issues where the Remaining Estimate is set to a particular value (i.e. a number, not a date or date range). "w"、"d"、"h"、"m" を使用して、週、日付、時間、分を指定します。 Note: this field does not support auto-complete. 構文
Alias (エイリアス):
フィールド タイプDURATION サポートされる演算子サポートされる関数n/a 例
^top of fields | ^^top of topic 報告者Search for issues that were reported by (i.e. created by) a particular user. 検索条件にはユーザーのフルネーム、ID またはメールアドレスを使用できます。 Note: this field supports auto-complete. 構文
フィールド タイプUSER サポートされる演算子サポートされる関数例
^top of fields | ^^top of topic ソリューションSearch for issues that have a particular Resolution 検索条件には解決策名または解決策 ID (例: JIRA が解決策に自動的に割り当てる番号) を使用できます。
Note: this field supports auto-complete. 構文
フィールド タイプRESOLUTION サポートされる演算子サポートされる関数n/a 例
^top of fields | ^^top of topic 解決済みSearch for issues that were resolved on, before or after a particular date (or date range). Note that if a time-component is not specified, midnight will be assumed. Please note that the search results will be relative to your configured time zone (which is by default the JIRA server's time zone). Note: this field does not support auto-complete. 構文
Alias (エイリアス):
フィールド タイプDATE サポートされる演算子サポートされる関数例
^top of fields | ^^top of topic ステータスSearch for issues that have a particular Status. 検索条件にはステータス名またはステータス ID (例: JIRA がステータスに自動的に割り当てる番号) を使用できます。
Note: this field supports auto-complete. 構文
フィールド タイプSTATUS サポートされる演算子サポートされる関数n/a 例
^top of fields | ^^top of topic 要約Search for issues where the Summary contains particular text. JIRA text-search syntax can be used. Note: this field does not support auto-complete. 構文
フィールド タイプTEXT サポートされる演算子サポートされる関数n/a 例
^top of fields | ^^top of topic Textこれは、次のすべてのテキスト フィールドを検索できる "マスター フィールド" です。 Note: The 構文
フィールド タイプTEXT サポートされる演算子サポートされる関数n/a 例
^top of fields | ^^top of topic タイプSearch for issues that have a particular Issue Type. 検索は課題タイプ名または課題タイプ ID (例: JIRA が課題タイプに自動的に割り当てる番号) のいずれかに基づいて行われます。
Note: this field supports auto-complete. 構文
Alias (エイリアス):
フィールド タイプISSUE_TYPE サポートされる演算子サポートされる関数n/a 例
^top of fields | ^^top of topic 消費時間Only available if time-tracking has been enabled by your JIRA administrator. Search for issues where the Time Spent is set to a particular value (i.e. a number, not a date or date range). "w"、"d"、"h"、"m" を使用して、週、日付、時間、分を指定します。 Note: this field does not support auto-complete. 構文
フィールド タイプDURATION サポートされる演算子サポートされる関数n/a 例
^top of fields | ^^top of topic 更新日Search for issues that were last updated on, before or after a particular date (or date range). Note that if a time-component is not specified, midnight will be assumed. Please note that the search results will be relative to your configured time zone (which is by default the JIRA server's time zone). Note: this field does not support auto-complete. 構文
Alias (エイリアス):
フィールド タイプDATE サポートされる演算子サポートされる関数例
^top of fields | ^^top of topic 投票者Search for issues for which a particular user has voted. You can search by the user's Full Name, ID or Email Address. Note that you can only find issues for which you have the "View Voters and Watchers" permission, unless you are searching for your own votes. See also votedIssues. Note: this field supports auto-complete. 構文
フィールド タイプUSER サポートされる演算子サポートされる関数例
^top of fields | ^^top of topic 投票数Search for issues with a specified number of votes. Note: this field does not support auto-complete. 構文
フィールド タイプNUMBER サポートされる演算子サポートされる関数n/a 例
^top of fields | ^^top of topic ウォッチャーSearch for issues that a particular user is watching. You can search by the user's Full Name, ID or Email Address. Note that you can only find issues for which you have the "View Voters and Watchers" permission, unless you are searching for issues where you are the watcher. See also watchedIssues. Note: this field supports auto-complete. 構文
フィールド タイプUSER サポートされる演算子サポートされる関数例
^top of fields | ^^top of topic ウォッチャーSearch for issues with a specified number of watchers. Note: this field does not support auto-complete. 構文
フィールド タイプNUMBER サポートされる演算子サポートされる関数n/a 例
^top of fields | ^^top of topic Work Ratio (作業率)Only available if time-tracking has been enabled by your JIRA administrator. Work Ratio (作業率) が特定の値の課題を検索します。 Work Ratio is calculated as follows: workRatio = timeSpent / originalEstimate) x 100 Note: this field does not support auto-complete. 構文
フィールド タイプNUMBER サポートされる演算子サポートされる関数n/a 例
|
A function in JQL appears as a word followed by parentheses which may contain one or more explicit values or JIRA fields. In a clause, a function is preceded by an operator, which in turn is preceded by a field. A function performs a calculation on either specific JIRA data or the function's content in parentheses, such that only true results are retrieved by the function and then again by the clause in which the function is used.
List of Functions:
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 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 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サポートされる演算子例
|
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.
You can use Lucene's text-searching features when performing searches on the following fields, using the CONTAINS operator:
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.
Auto-complete suggestions are not offered for all fields. Check the fields reference to see which fields support auto-complete. If you type a space at the start of your query......JIRA will offer a list of all available fields, e.g.:
If you type one or more characters......JIRA will offer a list of matching fields, e.g.:
If you type a field then a space......JIRA will offer a list of valid operators, e.g.:
If you type a field, then an operator, then a space......JIRA will offer a list of valid values, e.g.:
If you type a field, then an operator, then one or more characters......JIRA will offer a list of valid values (if your field supports this) and valid functions for the field/operator combination, e.g.:
|
In general, a query created using 'Simple Search' will be able to be translated to 'Advanced Search' (i.e. JQL), and back again.
However, a query created using 'Advanced Search' may not be able to be translated to 'Simple Search', particular if:
project in (A, B))(project = JRA OR project = CONF) is equivalent to this query:(project in (JRA, CONF)), only the second query will be translated.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 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.)