Avensoft Help Desk - IS NOT Closed By someone condition excludes requests not closed

IS NOT Closed By someone condition excludes requests not closed

When you define a condition like this in an advanced report:

Closed By IS NOT someone

You would only get requests that are closed. This is because the above translates to this:

sr_closed_by <> someone

SQL Server excludes records with sr_closed_by IS NULL. Hence only the closed requests are returned.

To resolve the problem, you can create a condition group like this:

(
Closed By IS NOT someone
OR Closed By IS {No One}
)

Then it would translate to this:

sr_closed_by <> someone OR sr_closed_by IS NULL

The requests that are not closed are then returned.