Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

JIRA jql Query - what * means?

Tags:

regex

jira

jql

There is no regexp in JQL: https://answers.atlassian.com/questions/138055/how-can-i-use-regex-in-a-jql-query-i-cannot-match-strings-that-have-a-specific-ending-in-jql-ex-ing-should-match-running-jogging-etc

What is the meaning of * in a jql Query?, I have different results when using and not using it. But I didn't find any consequence in the results.

like image 224
nagy.zsolt.hun Avatar asked Feb 22 '13 11:02

nagy.zsolt.hun


People also ask

How do you do a wildcard in JQL?

There are two types of wild-cards in JQL: ? and * where: To perform a single character wildcard search use the "?" symbol. To perform a multiple character wildcard search use the "*" symbol.

What does != Mean in JQL?

The " != " operator is used to search for issues where the value of the specified field does not match the specified value. (Note: cannot be used with text fields; see the DOES NOT MATCH (" !~ ") operator instead.)

How do I find special characters in JQL?

if you are searching a text field and the character is on the list of special characters in text searches, precede them with two backslashes. This will let you run the query that contains a reserved character, but the character itself will be ignored in your query.

What are JQL keywords?

A keyword in JQL is a word or phrase that does (or is) any of the following: joins two or more clauses together to form a complex JQL query. alters the logic of one or more clauses. alters the logic of operators. has an explicit definition in a JQL query.


1 Answers

~ means CONTAINS, so

summary ~ win

means WHERE summary CONTAINS the exact word win. * is a wildcard. The example:

summary ~ "win*"

means WHERE summary CONTAINS win and any multiple character combination after it.

There are two types of wild-cards in JQL: ? and * where:

  1. To perform a single character wildcard search use the "?" symbol.
  2. To perform a multiple character wildcard search use the "*" symbol.

Check the JIRA advanced searching guide and the wild-card explanation here.

like image 55
Borislav Sabev Avatar answered Oct 08 '22 00:10

Borislav Sabev