In 4.0, it is now possible to query of off constituents from the Data Warehouse. When using a selection created from a 'Constituents (from the Blackbaud Data Warehouse)' query view in another query, a user may notice that no records are returned even though there are records in the query the selection was based off of.
We're currently evaluating this issue for a fix in a future patch or service pack.
Workaround for this situation: This has been addressed in some cases by changing the connection string in web.config to use 'integrated security=sspi'. Previously it was set to use a specific user.
Steps to Duplicate
Steps to duplicate:
1. Log-in to Texas Christian 4.0 environment.
2. Go to Analysis, Information Library, and add a Constituents (from the Blackbaud Data Warehouse)
3. Set any filters, run the results to confirm you have records, and save a selection to be used in Query Designer.
4. Add a Constituent Query and select your selection as a filter (exists in = yes). Run the results of this query and notice you receive 0 records.