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