Created in 2016 by Atlassian. Licensed under a .Creative Commons Attribution 2.5 Australia License
Reserved characters
JQL has a list of reserved characters:
space (" ") + . , ; ? | * / % ^ $ # @ [ ]
If you wish to use these characters in queries, you need to:
surround them with quote-marks (you can use either single quote-marks ( ) or double quote-marks ( )' "
);
if you are searching a text field and the character is on the list of and, reserved characters for text
,searches
precede them with two backslashes.
For example:
version = "[example]"
summary ~ "\\[example\\]"
Reserved words
JQL also has a list of reserved words. These words need to be surrounded by quote-marks (single or double)
if you wish to use them in queries.
Show me...
"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"
Note for JIRA administrators: this list is hard coded in the file.JqlStringSupportImpl.java
Performing text searches
You can use Lucene's text-searching features when performing searches on the following fields, using
the CONTAINS operator:
Summary, Description, Environment, Comments, custom fields that use the "Free Text Searcher" (i.e. custom
fields of the following built-in custom field types: Free Text Field, Text Field, Read-only Text Field).
For more information, see .Search syntax for text fields
Reference
Description Reference