JQL Issue : how to search a keyword in a field

Hi all!

I met some difficulties to create JQL queries in order to search for keywords in my JIRA database.

For example I would like to find all JIRA files which contain a keyword (example : issue) and the actual year 2013.

so I've tried to write this summary ~ "2013 && issue"

Unfortunatey as a result, I have only the JIRA with the summary like ".... issue .... 4 Jan 2013...." (I am french)

I cannot see the JIRA with the summary like ".... issue .... 04/01/2013...."

What is the correct JIRA query in order to see all these JIRA files? (in fact like the sql query "LIKE '%issue%2013%'?

Thanks in advance for your help

Antho

2 answers

If I get you right, you want to search for two different keyword in the summary?

summary ~ "keyword" AND summary ~ "2013"

This finds a summary like "...keyword...2013..."

It has the same action as "summary ~ "2013 && issue"". The JIRA with the words "XX/XX/2013" are still missing.

The problem is that JIRA select only the summaries where 2013 is not concatenated with other letters. I have tried to write summary ~ "*2013" but as a result it gave me an error.

The problem is you cannot use wildcard at the beginning of a phrase.But there is a way, it looks aweful but this should work.

summary~"issue" and summary~"01/01/2013 02/01/2013 03/01/2013 04/01/2013 05/01/2013 06/01/2013 07/01/2013 08/01/2013 09/01/2013 10/01/2013 11/01/2013 12/01/2013 13/01/2013 14/01/2013 15/01/2013 16/01/2013 17/01/2013 18/01/2013 19/01/2013 20/01/2013 21/01/2013 22/01/2013 23/01/2013 24/01/2013 25/01/2013 26/01/2013 27/01/2013 28/01/2013 29/01/2013 30/01/2013 31/01/2013 01/02/2013 02/02/2013 03/02/2013 04/02/2013 05/02/2013 06/02/2013 07/02/2013 08/02/2013 09/02/2013 10/02/2013 11/02/2013 12/02/2013 13/02/2013 14/02/2013 15/02/2013 16/02/2013 17/02/2013 18/02/2013 19/02/2013 20/02/2013 21/02/2013 22/02/2013 23/02/2013 24/02/2013 25/02/2013 26/02/2013 27/02/2013 28/02/2013 01/03/2013 02/03/2013 03/03/2013 04/03/2013 05/03/2013 06/03/2013 07/03/2013 08/03/2013 09/03/2013 10/03/2013 11/03/2013 12/03/2013 13/03/2013 14/03/2013 15/03/2013 16/03/2013 17/03/2013 18/03/2013 19/03/2013 20/03/2013 21/03/2013 22/03/2013 23/03/2013 24/03/2013 25/03/2013 26/03/2013 27/03/2013 28/03/2013 29/03/2013 30/03/2013 31/03/2013 01/04/2013 02/04/2013 03/04/2013 04/04/2013 05/04/2013 06/04/2013 07/04/2013 08/04/2013 09/04/2013 10/04/2013 11/04/2013 12/04/2013 13/04/2013 14/04/2013 15/04/2013 16/04/2013 17/04/2013 18/04/2013 19/04/2013 20/04/2013 21/04/2013 22/04/2013 23/04/2013 24/04/2013 25/04/2013 26/04/2013 27/04/2013 28/04/2013 29/04/2013 30/04/2013 01/05/2013 02/05/2013 03/05/2013 04/05/2013 05/05/2013 06/05/2013 07/05/2013 08/05/2013 09/05/2013 10/05/2013 11/05/2013 12/05/2013 13/05/2013 14/05/2013 15/05/2013 16/05/2013 17/05/2013 18/05/2013 19/05/2013 20/05/2013 21/05/2013 22/05/2013 23/05/2013 24/05/2013 25/05/2013 26/05/2013 27/05/2013 28/05/2013 29/05/2013 30/05/2013 31/05/2013 01/06/2013 02/06/2013 03/06/2013 04/06/2013 05/06/2013 06/06/2013 07/06/2013 08/06/2013 09/06/2013 10/06/2013 11/06/2013 12/06/2013 13/06/2013 14/06/2013 15/06/2013 16/06/2013 17/06/2013 18/06/2013 19/06/2013 20/06/2013 21/06/2013 22/06/2013 23/06/2013 24/06/2013 25/06/2013 26/06/2013 27/06/2013 28/06/2013 29/06/2013 30/06/2013 01/07/2013 02/07/2013 03/07/2013 04/07/2013 05/07/2013 06/07/2013 07/07/2013 08/07/2013 09/07/2013 10/07/2013 11/07/2013 12/07/2013 13/07/2013 14/07/2013 15/07/2013 16/07/2013 17/07/2013 18/07/2013 19/07/2013 20/07/2013 21/07/2013 22/07/2013 23/07/2013 24/07/2013 25/07/2013 26/07/2013 27/07/2013 28/07/2013 29/07/2013 30/07/2013 31/07/2013 01/08/2013 02/08/2013 03/08/2013 04/08/2013 05/08/2013 06/08/2013 07/08/2013 08/08/2013 09/08/2013 10/08/2013 11/08/2013 12/08/2013 13/08/2013 14/08/2013 15/08/2013 16/08/2013 17/08/2013 18/08/2013 19/08/2013 20/08/2013 21/08/2013 22/08/2013 23/08/2013 24/08/2013 25/08/2013 26/08/2013 27/08/2013 28/08/2013 29/08/2013 30/08/2013 31/08/2013 01/09/2013 02/09/2013 03/09/2013 04/09/2013 05/09/2013 06/09/2013 07/09/2013 08/09/2013 09/09/2013 10/09/2013 11/09/2013 12/09/2013 13/09/2013 14/09/2013 15/09/2013 16/09/2013 17/09/2013 18/09/2013 19/09/2013 20/09/2013 21/09/2013 22/09/2013 23/09/2013 24/09/2013 25/09/2013 26/09/2013 27/09/2013 28/09/2013 29/09/2013 30/09/2013 01/10/2013 02/10/2013 03/10/2013 04/10/2013 05/10/2013 06/10/2013 07/10/2013 08/10/2013 09/10/2013 10/10/2013 11/10/2013 12/10/2013 13/10/2013 14/10/2013 15/10/2013 16/10/2013 17/10/2013 18/10/2013 19/10/2013 20/10/2013 21/10/2013 22/10/2013 23/10/2013 24/10/2013 25/10/2013 26/10/2013 27/10/2013 28/10/2013 29/10/2013 30/10/2013 31/10/2013 01/11/2013 02/11/2013 03/11/2013 04/11/2013 05/11/2013 06/11/2013 07/11/2013 08/11/2013 09/11/2013 10/11/2013 11/11/2013 12/11/2013 13/11/2013 14/11/2013 15/11/2013 16/11/2013 17/11/2013 18/11/2013 19/11/2013 20/11/2013 21/11/2013 22/11/2013 23/11/2013 24/11/2013 25/11/2013 26/11/2013 27/11/2013 28/11/2013 29/11/2013 30/11/2013 01/12/2013 02/12/2013 03/12/2013 04/12/2013 05/12/2013 06/12/2013 07/12/2013 08/12/2013 09/12/2013 10/12/2013 11/12/2013 12/12/2013 13/12/2013 14/12/2013 15/12/2013 16/12/2013 17/12/2013 18/12/2013 19/12/2013 20/12/2013 21/12/2013 22/12/2013 23/12/2013 24/12/2013 25/12/2013 26/12/2013 27/12/2013 28/12/2013 29/12/2013 30/12/2013 31/12/2013"

Suggest an answer

Log in or Sign up to answer
Community showcase
Posted Sep 25, 2018 in Jira

Atlassian Research Workshop opportunity on Sep. 28th in Austin, TX

We're looking for participants for a workshop at Atlassian! We need Jira admins who have interesting custom workflows, issue views, or boards. Think you have a story to sha...

442 views 7 5
Join discussion

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you