I am having a problem restricting a report using OR Clauses.
I want to create a report in EazyBI which replicates the following JQL:
project = Project1 AND statusCategory != Done AND (fixVersion = "Version1" OR affectedVersion = "Version1" AND (Severity in (High, Critical) OR priority in (High, Highest) OR "Customer Priority" in (Critical, High)))
I have added FixVersion and AffectedVersion in Pages and but by limiting the table using the dropdown will results in
fixVersion = “Version1” AND affectedVersion = “Version1”.
How do I restrict to either of these Fields?
Once I am able to limit the report to
fixVersion = "Version1" OR affectedVersion = "Version1"
I want to further restrict it for the criteria above, i.e I only want High/Critical Issues, by severity OR priority OR customer priority, where affected version = “Version 1”