Advanced searching - keywords reference
AND
Used to combine multiple clauses, allowing you to refine your search.
You can also use parentheses to control the order in which clauses are executed. See Precedence in JQL queries for details.
OR
Used to combine multiple clauses, allowing you to expand your search.
You can also use parentheses to control the order in which clauses are executed. See Precedence in JQL queries for details.
Check out the usage of IN operator, which can be a more convenient way to search for multiple values of a field.
NOT
Used 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.
Check out the usage of NOT EQUALS ("!="), DOES NOT CONTAIN ("!~"), NOT IN and IS NOT operators that are often used to negate clauses in a JQL query.
EMPTY
Used 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.
NULL
Used 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.
ORDER BY
Used to specify the fields by whose values the search results will be sorted.
By default, the field's own sorting order will be used. You can override this by specifying ascending order ("asc
") or descending order ("desc
").
Ordering by Components or Versions will list the returned issues first by Project, and only then by the field's natural order (see JRA-31113).