summary query is pulling in too many results

Meghan O_Lone

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

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

 

Gustavo Félix_5ziaxu

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?