Query excluding constituency returning records with that constituency

Constituent records with a specific constituency are returned in Query results that is excluding records with the same constituency, even though the results/excel file from the query do not show the constituency itself.

For example, the results from the query appear to be accurate; however, when reviewing the constituent records in CRM, some of the returned records have the excluded constituency on their constituency tab.
We’re currently evaluating this issue for a fix in a future release.

Steps to Duplicate

  1. Go to Constituent
  2. Click Add an Individual
  3. Create a new record by entering First and last name, click Save
  4. Go to the Constituencies tab, click Add and then click Staff
  5. Click Save (No Date From/To needed)
  6. Go to Analysis > Query
  7. Click Add, then Add Ad-Hoc Query
  8. Highlight Constituents, click OK
  9. Add Criteria similar to the following: http://screencast.com/t/BwqeTrwpYc
  10. Click Export to Excel and save the results
  11. Note that the constituent record added above in steps 2 - 5 with Staff constituency) is in the results even though the constituent Staff is not listed in the results

Environment

 Blackbaud CRM
 3.0

Was this article helpful?