153 words that will break your JIRA JQL searches

  • Taille du texte: Agrandir Réduire
  • Notifications
  • Imprimer
153 words that will break your JIRA JQL searches

The JIRA query language (JQL) is a great feature in JIRA. It's used to find issues based on search queries. Although JQL is a language unique to JIRA, it's pretty easy to learn and use even for non technical users like myself. Like every query Language, some words are reserved to JQL and cannot be used in queries like standard words.

 

In order to use these words in a query, you have to put the word in a single (') or double (") quotation mark.

For example, if you are searching for issues in a project named transaction, you would have to write the query this way:

project = "'transaction'".

 

For more information on JQL and advanced searching in JIRA visit: 

https://confluence.atlassian.com/display/JIRA062/Advanced+Searching

Here is the list of JQL reserved words:

"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"

 

Mots clés: jira
dans JIRA Lectures : 8545 0 commentaires

Aleksandar Mincic joined the TechSolCom Atlassian Practice in January 2014 and specializes in Requirements Gathering, Analysis, JIRA Workflow Design, and overall JIRA Configuration.

Voici les derniers articles de cet utilisateur:

Commentaires

  • Pas encore de commentaire. Soyez le premier à commenter

Commenter cet article

Invité
Invité lundi, 11 décembre 2017