Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,365,330
Community Members
 
Community Events
168
Community Groups

summary query is pulling in too many results

I want to pull a filter for ONLY "AT Findings" subtasks. This is my current query, and it's pulling back AT Findings subtasks as well as Design, Auto, and Content findings (see first screenshot)

 

Query 1: project = DP AND "Parent Feature ID" ~ DP-10237 AND issuetype in ("Technical Task", "Development Subtask") AND (summary ~ "AT Findings") AND status not in (Completed, Closed, "Ready to Migrate to UAT")

jira question - at findings.JPG

When i do THE SAME query but switch "AT Findings" with "Design Findings", it's pulling back only Design Findings subtasks (see second screenshot). Why? Please help

Query 2: project = DP AND "Parent Feature ID" ~ DP-10237 AND issuetype in ("Technical Task", "Development Subtask") AND (summary ~ "Design Findings") AND status not in (Completed, Closed, "Ready to Migrate to UAT")

jira question - design findings.JPG

 

1 answer

1 accepted

2 votes
Answer accepted

Hi @Meghan O_Lone 

I was really curious about this, so I found https://community.atlassian.com/t5/Jira-questions/JQL-Query-to-filter-out-issues-where-Summary-contains-a/qaq-p/321309

It says that there are some reserved words, so it might not work well. 
Based on this comment : "

Hi guys, it doesnt work because "be" is reserved word for JQL, it can be used as verb.

To use it you have to escape it similarly as Eren did (\"[BE]\") so in your case just \"BE\" should work"

I tried summary ~ "\"[AT]\" Findings" and it worked.

Can you try and let me know if it works?

This worked!!!! Thank you so much @Gustavo Félix you are a lifesaver!! 

Like Gustavo Félix likes this

Great!

Like Meghan O_Lone likes this

Suggest an answer

Log in or Sign up to answer
TAGS

Atlassian Community Events