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

[Nic Brough -Adaptavist- · Accepted solution]

Yes, that's a function of older data and can happen in cases where users are being moved around (renamed, deleted, directories etc)

This is one of many reasons that you should not be reading the database.  It's not built for reporting.

[Vadim Shtukan]

Thanks for the answer. Can you suggest somethink that will be usable for reporting?

[Nic Brough -Adaptavist-]

Use the API - internal if you're on server and happy to code in there, or REST if you are on Cloud, or don't want to code internally.  Or take a look in the marketplace for add-ons that can do what you want to report on.