Incorrect query results when querying on RE7 Prospect Ratings

Querying on prospect ratings values returns constituents that meet any single piece of the criteria rather than the criteria in aggregate.
This will be resolved in the next version of BBDM.  Until then, as a workaround, we can export the list from RE where the query works correctly and then import it as a selection into BBDM.

Steps to Duplicate

1.  Create a query based on RE7 constituents with the following criteria:
  Constituent\Prosptect\Ratings\Source = Value
  Constituent\Prosptect\Ratings\Category = Capacity Rating
  Constituent\Prosptect\Ratings\Description is between $499 - $1000
2.  View the output.  Note that constituents are returned that don't meet the criteria

Was this article helpful?