Site secured solicit codes cannot be filtered on in the Constituents (from the Blackbaud data warehouse) query view in AdHoc query

Users may find that they are unable to use site secured solicit code names as filters in AdHoc query when using the Constituents (from the Blackbaud data warehouse) query view.
 We are currently evaluating this issue for a fix in a future service pack.
 

Steps to Duplicate

  1. Add a solicit code that is site secured or add site security to an existing code.
  2. Refresh the BBDW.
  3. Start a new AdHoc query using the Constituents(From Blackbaud datawarehouse) view
  4. Filter by solicit code\solicit code equal to [select name of solicit code] from step 1.
  5. Output the solicit code name.
  6. Note there are 0 results.

Environment

 Blackbaud CRM
 4.0
 4.0.180.1716

Was this article helpful?