Query operator Does Not Contain omits blank values in query results in RE 7.93

When using the query operator Does Not Contain on fields with text values, blank results are omitted in The Raiser's Edge 7.93, whereas they were included in results using same query criteria in The Raiser's Edge 7.92.

Article Number: 67822

Products:

  • Raiser_s_Edge_RE
Download and install the latest patch, which contains all fixes from previous patches. If you are running an older version, download and install the latest version and then the patch. 

Alternative solution:

In The Raiser's Edge 7.93, use a query criteria as follows if Does Not Contain needs to consider blank values:

(<field> does not contain <enter your text>
OR <field> blank)

Environment

 7.93.5782
 7.93.5782, patch 5

Was this article helpful?

Blackbaud Community

Connect and collaborate with fellow Blackbaud users.

Chat with Support

Chat with our experienced staff to receive help right away.

Connect

The Blackbaud team is online and ready to connect with you!