JIRA jql Query - what * means?

regex jira jql
nagy.zsolt.hun picture nagy.zsolt.hun · Feb 22, 2013 · Viewed 17.3k times · Source

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.

Answer

Borislav Sabev picture Borislav Sabev · Feb 23, 2013

~ 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.

Related questions

Regular expression for a JIRA identifier

I'm trying to extract a JIRA identifier from a line of text. JIRA identifiers are of the form [A-Z]+-[0-9] - I have the following pattern: foreach my $line ( @textBlock ) { my ( $id ) = ( $line =~ /[\s|]?([A-Z]+-[0-9]+)[\s:|]?/ ); push @…

Read More
Regular expression to match a line that doesn't contain a word

I know it's possible to match a word and then reverse the matches using other tools (e.g. grep -v). However, is it possible to match lines that do not contain a specific word, e.g. hede, using a regular …

Read More
How to validate an email address in JavaScript

Is there a regular expression to validate an email address in JavaScript?

Read More