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 Join to answer
Community showcase
Sarah Schuster
Posted Jan 29, 2018 in Jira

What are common themes you've seen across successful & failed Jira Software implementations?

Hey everyone! My name is Sarah Schuster, and I'm a Customer Success Manager in Atlassian specializing in Jira Software Cloud. Over the next few weeks I will be posting discussion topics (8 total) to ...

2,789 views 11 18
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
Atlassian Team Tour

Join us on the Team Tour

We're bringing product updates and pro tips on teamwork to ten cities around the world.

Save your spot