Multiple keywords in filter not working as expected

[Kay Bowen]

I'm trying to run a query with multiple AND keywords but I'm not seeing the results I expect.

I want to see all stories that have completed in the current sprint but were over or under-estimated but the below query brings back subtasks and doesn't include the under-estimated items from what I can see

This is my current query:

project = SWOW AND type = Story AND status = Done AND Sprint in openSprints() AND remainingEstimate > 0 OR workRatio > 100

[Support Team [Clearvision]]

Hi Kay,

Could you try something like:

project = SWOW AND type = Story AND status = Done AND Sprint in openSprints() AND (remainingEstimate > 0 OR workRatio > 100)

Using 'OR' without brackets separates your query into 2 parts so you end up getting 2 lots of results essentially. For example you likely have a list of issues matching

project = SWOW AND type = Story AND status = Done AND Sprint in openSprints() AND remainingEstimate > 0

As well as all issues matching

workRatio > 100

Hopefully with it contained after the 'AND' it should treat it that they all must match.