Default AND operator in report on dashboard

  • 2
  • Problem
  • Updated 6 days ago
  • Acknowledged
Hello Team

We have a report in a dashboard that already has a condition

A AND B AND (C OR D) set by admin

Dynamically when I try to add a new condition I would want it to be a OR Condition but by default it takes AND Condition because of which it becomes

A AND B AND (C OR D) AND E but in my case C D and E are all same fields so it wouldnt ever
give any records.
Photo of Jahnavi

Jahnavi, Champion

  • 1,756 Points 1k badge 2x thumb

Posted 2 weeks ago

  • 2
Photo of Lila Meyer

Lila Meyer, Official Rep

  • 15,116 Points 10k badge 2x thumb
Hi Jahnavi,

I reached out to our Support team to help investigate. Thanks for reporting the issue!
Photo of Dan Ahrens

Dan Ahrens, Gainster (employee)

  • 22,658 Points 20k badge 2x thumb
This looks like a good product enhancement request for our reporting team. Here's a screen shot of what Jahnavi is describing. 

In this example there is an admin set filter on this report containing options A through M with many of them set as OR conditions for the various assignees. If I wanted to add my name to that filter as another optional assignee, the only logic choice I am given is AND, which would break the results of the report.