Summary Search not working as expected

[Rahul Mittal]

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?

[Hazwan Ariffin]

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\""

[Rahul Mittal]

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?

[Andrew Laden]

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.