Query doesn't return all results

[David Burgdorf]

I have a filter where if I do this query I get  1128 records back

filter in ("10879") and priority in (High, Medium, Low, None) order by priority

when I do individual queries

filter in ("10879") and priority = High Order by priority  -> returns  71

filter in ("10879") and priority = Medium Order by priority  -> returns  520

filter in ("10879") and priority = Low Order by priority  -> returns  286

filter in ("10879") and priority = None Order by priority  -> returns  198

filter in ("10879") and priority is Empty Order by priority  -> returns  0

this totals 1075 records.  where are the other 53 records

[John Funk]

Hi David - Welcome to the Atlassian Community!

If you do the full query and order by priority, when you go through all of those, do you see any other values in there for Priority or do you see any issues without a priority (null)? 

[Tuncay Senturk]

Hi @David Burgdorf 

It might be due to the filter itself; I mean, there may be a misuse of parentheses.

Additionally, try this query to find the possible priorities that issues can have:

filter in ("10879") and priority not in (High, Medium, Low, None) order by priority

[David Burgdorf]

this returns no rows

[Tuncay Senturk]

How about trying to wrap that filter parts in parentheses?

(filter in ("10879") ) and ...

[David Burgdorf]

project in ("App Core", "App Infrastructure", CodeBusters, "Event Organizers") AND issuetype = Bug AND status in (New, Blocked, "In Progress", "In Review", "To Do", "Ready for QA", Testing) order by created DESC

[Kim Euker]

Can you post the JQL for your 10879 Filter?

[Kate C_]

@David Burgdorf sorry you're having trouble replying to @Kim Euker's question. Can you try and post any text, rather than the JQL, and then edit your reply. Does that work?

If not, please email the community management team at communitymanagers@atlassian.com and we'll try and post it for you!

[David Burgdorf]

The filter is:
project in ("App Core", "App Infrastructure", CodeBusters, "Event Organizers") AND issuetype = Bug AND status in (New, Blocked, "In Progress", "In Review", "To Do", "Ready for QA", Testing) order by created DESC