created >= startOfYear() AND assignee = name1 OR assignee = name2

Ankit Jain_tcwbnt

Hi We are using self hosted Jira v8.5.3

I am trying to export results but when I combine two or more than two users using "OR" it outputs results for December 2021 and for year 2022(current year is 2022) also but when I use single user it outputs correctly that is for year 2022 only

 

I want to know why it shows wrong output when combined users???  Why It is taking December 2021 in current year 2022

 

Nic Brough -Adaptavist-

Welcome to the Atlassian Community!

When mixing AND and OR statements in a filter, Jira needs guidance on how you want to join the clauses.  Without any, it simply reads left to right across your query.

The query you have written works out as

created >= startOfYear() AND assignee = name1

OR

assignee = name2

So it's returning everything for the second assignee.

Try created >= startOfYear() AND ( assignee = name1 OR assignee = name2 )