Smart Query performs slowly for users using a non-base currency

Users who are defaulted to a specific currency set can choose non-base currencies when configuring smart queries.  However, when these queries are executed, they take much longer to run than for users with no currency set associated with their username, which means they only create queries using the base currency.  This can be demonstrated using the Donor List smart query.
We're currently evaluating this issue for a fix in a future patch or service pack.  

Steps to Duplicate

1. Log in with a user who has a specific currency set
2. Go to Analysis, Information Library, Add a new Smart Query
3. Create a donor list smart query
4. Choose the Date range 01/01/14 through 12/30/14
5. Set the amount greater than 999. Euros (non base currency of your choice)
This query takes several minutes to run.  

6. Save this query
7. Access the application with a user who has no default currency set.
8. Preview the same query
Now this  will run in about 2 minutes.

Environment

 Blackbaud CRM
 3.0

Was this article helpful?