Summary Search not working as expected

Question

Hi All,

I am trying to list tickets matching certain criteria (as shown in the attachment).

Requirement : List tickets that has word "Production" along with certain other criterias.

Problem: The response also return the tickets which do not have Production

JQL : project in (TEST1) and type = milestone and ('start date' >= 2020-03-01 and 'Start Date' < 2020-04-01) and summary ~ "Production" and resolution = unresolved

Refer attachment

Any suggestions or leads?

Andrew Laden · Answer

You are probably running into issues with "Word Stemming"

Take a look at:

https://confluence.atlassian.com/jirasoftwareserver/search-syntax-for-text-fields-939938747.html

You may want to try some other seaches not using ~ but using = with wildcards.

Rahul Mittal_lixvbd · Answer

Tried but still getting some (lesser than earlier) unwanted tickets without "production" in the summary line.

Is it strange or I am using contains (~) incorrectly?

Hazwan Ariffin · Answer

Try this

project in (TEST1) and type = milestone and ('start date' >= 2020-03-01 and 'Start Date' < 2020-04-01) and resolution = unresolved and text ~ "\"Production\""